top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Find and later delete zombie informatica objects

0 votes
221 views

Is there a easy way to identify and clean unused informatica artifacts?

Context: In one of the projects, there are lot of zombie sessions / mappings etc, the creators have long gone.

I want to do the following:

List/Delete all sessions that are not associated with a workflow.
List/Delete all mappings that are not used in any session/wf.
List/Delete all source/target that were not used in any mapping.
List/Delete all workflows that were not run in the past one year.
Someone mentioned about using : Designer > Tools > Queries . I can't express the above 1/2/3/4 with the option given, can anyone shed some light?

Note:

I’m not looking for click one by one and find dependencies.
I’m not looking for download the whole plant as xml and search dependencies one by one

posted Jul 16, 2014 by Amit Sharma

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+1 vote
Informatica export objects

I am exporting objects from informatica repository using unix script.

I used following command to export the mapping.
pmrep objectexport -n -o mapping -f -u

it is working fine. But when I tried to export one expression transformation in mapping it's giving error as the 'The transformation object doesn't exist' 

To export expression I used following command,
 pmrep objectexport -n <expression_name> -o transformation -t expression -f <folder_name> -m -s -b -r -u <export_path>

Can anyone help me on this?

+2 votes
How to delete the empty TAGS while publishing XML in Informatica Target

I am publishing a XML as Informatica Target and I am getting empty tags in the published file. I have already treid the below mentioned settings but still empty tags are coming.
XML null content representation-> No Tag
XML empty string content representation->No Tag
XML null attribute representation->No Attribute
XML empty string attribute representation->No Attribute
and below mentioned Custom Properties
WriteNullXMLFile=No;SuppressNilContentMethod=ByTree;

+2 votes
delete duplicate rows using informatica

How can we delete duplicate rows from source database table using informatica. This has to be done without using any other table. Means source and target is same table in Oracle database.

+1 vote
How to delete large number of rows without affecting Informatica replication?

I'm not exactly sure if it will cause an issue or not. But in our environment whenever selecting from large tables we need to include WITH(nolock) otherwise we get deadlocks between select statements and Informatica real time replication trying to populate those tables. Currently we are looking to use SQL jobs to purge old records from tables. Most tables will have less than 1000 rows deleted once a week. During initial purge process there will be several tables that will have millions of records deleted.

Not sure if it would be better to pause real time replication for duration of the purge or just to try to resolve conflicts once those arise.

I don't have a good way to test this in Dev environment because don't have same volume of people hitting server with request, real time updates and everything else that makes up normal load in production. In production this will be running once a week during slow hours that should minimize total load but still don't want to crash Informatica every time this is running.

Note: this question is NOT about how to write delete statements in SQL or breaking delete in small chunks but rather how to avoid conflicts with real time replication with Informatica product.

Database - SQL Server 2012
Replication - Informatica 9.0.1

...