top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica export objects

+1 vote
464 views

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?

posted Jan 20, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

You can export a reusable expression, that is a separate, independent object within the Repository. I'm afraid you can't export one transformation from within a mapping. If that is what you need, just export the whole mapping, edit it, and get the required transformation.

answer Jan 21, 2015 by Shweta Singh
Similar Questions
0 votes
Export details of workflow from Informatica Powercenter Monitor

I am new to informatica. Whenever we run any workflow its details are shown in the monitor. Everyday I need to prepare an excel report of those details manually.

I want to automate this process.

For this job I wanted to know in which file details of the workflow run are stored which are displyed by Informatica monitor. So that I can build a program which will read that file interprete the values and will create an Excel report automatically avoiding my Manual work.

Modification - By details of Workflow I mean...

The number of records which were provided as input to interface.
The number of records which were successfully processed and sent to target table.
The number of records which were rejected during the process.
The number of records which went into Exception table.
0 votes
Find and later delete zombie informatica objects

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

0 votes
How to use SQL case statement for informatica

Sql case statement is selecting the records but not returning the conditions in informatica

ex. Select *,case if emp_de = 'M' and leave is not null then 'Yes',when if emp_de = 'M' and leave is null then 'No' As 'Remark' end from EMP table where emp_Sal <2000.
the query is working fine in the informatica but the condition Yes or No not updating in the Remark port.

...