The point of this is to document research around refactoring the informatica integration around eliminating redundancy of shared objects, like sources, targets and mappings.
Listing all objects:
Listing objects
pmrep>listobjects
The option -o is required.
Usage: listobjects
-o <object_type>
[-t <object_subtype>]
[-f <folder_name>]
[-c <column_separator>]
[-r <end-of-record_indicator>]
[-l <end-of-listing_indicator>]
[-b (verbose)]
[-s < dbd_seperator>]
Failed to execute listobjects.
pmrep>
Some object types I tried: source, target, mapping, mapplet, session, workflow, transformation, “User Defined Function”, task, Deploymentgroup, label, folder, query, scheduler, sessionconfig, worklet.
Running normally just gives a list of objects:
Bare objects
pmrep>listobjects -o source -f __31343730353235323839333237_6_SHARED_EDW source FlatFile.FF_INT_CONVERSION_TEST .listobjects completed successfully. pmrep>
From which you can get a list of objects. If you need to know which are shortcuts, you can add -b:
Verbose listing
pmrep>listobjects -o source -f __31343730353235323839333237_6_SHARED_EDW -b source FlatFile.FF_INT_CONVERSION_TEST 1 source FlatFile.sc_FF_INT_CONVERSION_TEST 1 shortcut .listobjects completed successfully. pmrep>
It appears to add two columns: version number and the word shortcut if it is a shortcut.
Exporting:
Exporting an object by type
pmrep>objectexport -o source -f __31343730353235323839333237_6_SHARED_EDW -u c:\xml_out.xml -o source -n FlatFile.sc_FF_INT_CONVERSION_TEST
12/18/2013 19:34:21
Analyzing Object Dependencies...
Exporting selected objects in repository REP_SVC_CI ...
Exporting selected objects in folder __31343730353235323839333237_6_SHARED_EDW .
..
Fetching Source Defination [sc_FF_INT_CONVERSION_TEST] ...
Exporting Source Defination [sc_FF_INT_CONVERSION_TEST] ...
Export is completed.
Exported 1 object(s) - 0 Error(s), - 0 Warning(s)
objectexport completed successfully.
pmrep>
0 Comments