Informatica - Importing Workflows using PMREP OBJECTIMPORT

Hi Everyone,

Below are the commands to import the informatica objects to the given Folder.

Assume that your workflow export XML file and control file placed in the same location.

pmrep objectimport -i wf_export.xml -c import_control_file.xml -l /MyData/infa/logs/import.log

Sample Control file - importtestctlfile.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE IMPORTPARAMS SYSTEM "/MyUnixBox/informatica/pc86/server/bin/impcntl.dtd">
<IMPORTPARAMS>
<FOLDERMAP
  SOURCEFOLDERNAME="IFX"
  SOURCEREPOSITORYNAME="SRC_DEV_REPO"
  TARGETFOLDERNAME="IFX"
  TARGETREPOSITORYNAME="TGT_SIT1_REPO"/>
<TYPEFILTER TYPENAME="SOURCE"/>
<TYPEFILTER TYPENAME="TARGET"/>
<TYPEFILTER TYPENAME="MAPPLET"/>
<TYPEFILTER TYPENAME="MAPPING"/>
<TYPEFILTER TYPENAME="TRANSFORMATION"/>
<TYPEFILTER TYPENAME="CONFIG"/>
<TYPEFILTER TYPENAME="TASK"/>
<TYPEFILTER TYPENAME="SESSION"/>
<TYPEFILTER TYPENAME="SCHEDULER"/>
<TYPEFILTER TYPENAME="WORKFLOW"/>
<TYPEFILTER TYPENAME="SCHEDULER"/>
<TYPEFILTER TYPENAME="WORKLET"/>
<RESOLVECONFLICT>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="WORKFLOW"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="WORKLET"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="SESSION"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="MAPPING"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="MAPPLET"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Source definition"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Target definition"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Expression"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Filter"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Aggregator"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Rank"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Normalizer"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Router"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Sequence"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Sorter"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="update strategy"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Custom Transformation"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Lookup Procedure"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Transaction control"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Stored Procedure"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="External Procedure"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Joiner"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="SessionConfig"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Email"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Command"/>
<TYPEOBJECT RESOLUTION="REPLACE" OBJECTTYPENAME="Scheduler"/>
</RESOLVECONFLICT>
</IMPORTPARAMS>


Thanks for reading my Blog !

Read More

Informatica - Export objects using PMREP Command

Hi All,

Below are the commands to export different types informatica objects.


Export Object


Source
pmrep objectexport -n <DB.SourceName> -o Source -f <Folder_Name> -m -s -b -r –u <xml file name>;


Target
pmrep objectexport -n <TargetName> -o Target -f <Folder_Name> -m -s -b -r –u <xml file name>;


Transformation
pmrep objectexport -n  <Lookup_Name> -o Transformation -t lookup_procedure -f <Folder_Name> -m -s -b -r -u <XML_File_Name>;


Task
pmrep objectexport -n <Task_Name>  -o Task -t Command -f <Folder_Name>-m -s -b -r -u <XML_File_Name>;


Mapplet
pmrep objectexport -n <Mapplet_Name> -o Mapplet -f <Folder_Name> -m -s -b -r –u <XML_File_Name>; 


Mapping
pmrep objectexport -n <Mapping_Name> -o Mapping -f <Folder_Name> -m -s -b -r –u <XML_File_Name>;


Session
pmrep objectexport -n <Session_Name> -o Session -f <Folder_Name> -m -s -b -r –u <XML_File_Name>;


Worklet
pmrep objectexport -n <Worklet_Name> -o Worklet -f <Folder_Name> -m -s -b -r –u <XML_File_Name>;


Workflow
pmrep objectexport -n <Workflow_Name> -o Workflow -f <Folder_Name> -m -s -b -r –u <XML_File_Name>;



Thanks for reading my Blog !

Read More

Informatica - Working with PMREP Commands

Hi Everyone,

Below are some of the pmrep commands.

Connect Command
pmrep connect -r <Repository_Name> -d <Domain_Name> -n <User> -x <Password>

ListObjects Command
     
Workflow
pmrep listobjects -o workflow -f <Folder_Name> | sed '1,8d;/successfully/,$d' > wf_list.txt
     
Source
pmrep listobjects -o Source -f <Folder_Name> | sed '1,8d;/successfully/,$d' > Src_list.txt

Target
pmrep listobjects -o Target -f <Folder_Name> | sed '1,8d;/successfully/,$d' > Tgt_list.txt
  
Mapplet
pmrep listobjects -o Mapplet -f <Folder_Name> | sed '1,8d;/successfully/,$d' > Mpplt_list.txt

Transformation
pmrep listobjects -o Transformation -f <Folder_Name> | sed '1,8d;/successfully/,$d' > Trfn_list.txt
  
Worklet
pmrep listobjects -o Worklet -f <Folder_Name> | sed '1,8d;/successfully/,$d' > /wkt_list.txt
  
Stored Procedures
 pmrep listobjects -o transformation -t stored_procedure -f <Folder_Name> | sed '1,8d;/successfully/,$d' > sproc_list.txt
  
Reusable Sessions
pmrep listobjects -o session -f <Folder_Name> | sed '1,8d;/successfully/,$d' > ru_ssn_list.txt

All Folders
pmrep listobjects -o folder > fldr_list.txt;


Thanks for reading my Blog !

Read More