2 Replies Latest reply on Dec 2, 2015 3:12 PM by EC117524

    PMCMD Command to export mapping xml from reporsitory

    New Member

      Hi All,

       

      can anyone share me the PMCMD code to export and import mapping xml from Informatica reporsitory.

       

      Thanks in Advance!!

       

        • 1. PMCMD Command to export mapping xml from reporsitory
          New Member

          Hi Deepak ,

           

          "pmrep" command is used to export the objects:

           

          below is an example for the same :

           

          The following example exports a mapping named "map," which is located in folder1, to a file named map.xml:

           

          pmrep objectexport -n map -o mapping -f folder1 -u map.xml

           

          Regards ,

          Abhishek

          • 2. PMCMD Command to export mapping xml from reporsitory
            New Member

            ObjectExport

             

            Exports objects to an XML file defined by the powrmart.dtd file. You export an object by name. If you enter an object, you must enter the name of the folder that contains it. If you do not enter a version number, you export the latest version of the object.

            Use a persistent input file to specify different objects to export at one time. You can create this file by using the ExecuteQuery, Validate, or ListObjectDependencies pmrep commands. If you use the persistent input file, do not use the other parameters to specify objects.

            If you export a mapping, by default PowerCenter exports the mapping and its instances. If you want to include dependent objects, you must add the appropriate pmrep options. You can optionally include reusable and non-reusable dependent objects, objects referenced by shortcuts, and related objects in a primary key-foreign key relationship.

            To export mapping dependencies, you must use the -b and -r options.

            The ObjectExport command uses the following syntax:

             

            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>]

             

            Examples

             

            The following example exports a mapping named “map,” which is located in folder1, to a file named map.xml:

             

            objectexport -n map -o mapping -f folder1 -u map.xml

             

            The following example exports the objects identified in a persistent input file named persistent_input.xml to a file named map.xml:

             

            objectexport -i persistent_input.txt -u map.xml