Thursday, 9 May 2013

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 !

1 comment:

  1. Is there any way to list objects based on last saved time

    ReplyDelete