The point of this is to document research around refactoring the informatica integration around eliminating redundancy of shared objects, like sources, targets and mappings. This process is going to involve a LOT of interaction with pmrep, and will take a lifetime if each command is executed on it's own process. This should be done in conjunction with in process clients, or else write out listings and then create an export script and execute that.
Listing all 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:
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:
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 objects is done with the exportobject command:
pmrep>objectexport
The option -u is required.
Usage: objectexport
{{-n <object_name>
-o <object_type>
[-t <object_subtype>]
[-v <version_number>]
[-f <folder_name>]} |
-i <persistent_input_file>}
[-m (export pk-fk dependency)]
[-s (export objects referred by shortcut)]
[-b (export non-reusable dependents)]
[-r (export reusable dependents)]
-u <xml_output_file_name>
[-l <log_file_name>]
[-e < dbd_seperator>]
Failed to execute objectexport.
pmrep>
Generally, we should not use any of the -m, -s, -b or -r flags, since we want each object in it's own atomic container - and those flags seem to be off by default.
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>
Note that for a source, the source 'dbname' prefix is required (in this case, FlatFile).
pmrep>listobjectdependencies -n wkf_LOAD_ITMMVMT_AUD -o workflow -p both -f EDW_POS_TICKET -b REP_SVC_DEV EDW_POS_TICKET source FlatFile.sc_d_fct_nt_itmvmt_v20091109 1 shortcut REP_SVC_DEV EDW_POS_TICKET target sc_TICKET_AUD 1 shortcut REP_SVC_DEV SHARED_POS_ODS target TICKET_DETAIL_AUD 1 REP_SVC_DEV SHARED_POS_ODS target TICKET_SUBHEADER_AUD 1 REP_SVC_DEV EDW_POS_TICKET source_qualifier non-reusable m_LOAD_ITMMVMT_AUD.SQ_Shortcut_to_d_fct_nt_itmvmt_v20091109 1 REP_SVC_DEV EDW_POS_TICKET target sc_TICKET_DETAIL_AUD 1 shortcut REP_SVC_DEV SHARED_POS_ODS target TICKET_AUD 1 REP_SVC_DEV EDW_POS_TICKET sessionconfig default_session_config 1 REP_SVC_DEV EDW_POS_TICKET start non-reusable wkf_LOAD_ITMMVMT_AUD.Start 1 REP_SVC_DEV EDW_POS_TICKET target sc_ITMMVMT_AUD 1 shortcut REP_SVC_DEV EDW_POS_TICKET router non-reusable m_LOAD_ITMMVMT_AUD.RTRTRANS 1 REP_SVC_DEV EDW_POS_TICKET expression reusable sc_exp_STANDARDIZE_DATE_FORMAT 1 shortcut REP_SVC_DEV SHARED_POS_ODS sequence reusable seq_AUDIT_SK 1 REP_SVC_DEV SHARED_EDW expression reusable exp_STANDARDIZE_DATE_FORMAT 1 REP_SVC_DEV SHARED_POS_ODS target ITMMVMT_AUD 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_ITMMVMT_AUD.EXP_PREPARE_SUBHEADER 1 REP_SVC_DEV EDW_POS_TICKET scheduler non-reusable wkf_LOAD_ITMMVMT_AUD.Scheduler 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_ITMMVMT_AUD.EXP_PREPARE_DETAIL 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_ITMMVMT_AUD.EXP_TGT_ANCHOR_DETAIL 1 REP_SVC_DEV EDW_POS_TICKET mapping m_LOAD_ITMMVMT_AUD 1 REP_SVC_DEV SHARED_POS_ODS source FlatFile.d_fct_nt_itmvmt_v20091109 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_ITMMVMT_AUD.EXP_PREPARE_HEADER 1 REP_SVC_DEV EDW_POS_TICKET workflow wkf_LOAD_ITMMVMT_AUD 1 REP_SVC_DEV EDW_POS_TICKET sequence reusable sc_seq_AUDIT_SK 1 shortcut REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_ITMMVMT_AUD.EXP_ADD_PARAMETERS 1 REP_SVC_DEV EDW_POS_TICKET target sc_TICKET_SUBHEADER_AUD 1 shortcut REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_ITMMVMT_AUD.EXP_TGT_ANCHOR_TICKET_AUD 1 REP_SVC_DEV EDW_POS_TICKET session non-reusable wkf_LOAD_ITMMVMT_AUD.s_m_LOAD_ITMMVMT_AUD 1 . The total number of records returned: 28 listobjectdependencies completed successfully.
Add Comment