How to run the batch using pmcmd command?

Question

When we do not know the number of targets, Can we create the targets at run time using informatica Powercenter.

Suppose we have below source:
Employee:

Dept_ID      EmpName  Sal
10           A        200
11           B        100
10           C        200
10           D        400
12           E        500
12           F        400

...

It can have any number of distinct Dept_ID. I want to load all EmpName and Sal of a particular Dept_ID into a separate target table (i.e target name should be as Tar_10 or Tar_11 where 10 & 11 are Dept_ID).

Answer 1

Using Command task in the workflow
Step 1: Check if you have PMCMD available.
If you have informatica installed on your system that doesn’t mean you can execute this utility also, Use below command to find out this utility availability for your informatica installation. If not, Talk to your admin to check that your organization license has this utility in it or not.

find . -name “PMCMD” –print , Command need to be executed at INFA application root directory.

Step 2: If PMCMD is available.

Check if execute access is there for all. User group and others should have execute access to this utility.

Step 3: Configure SHLIB_PATH environment variable.

Bottom line, To run this utility, you got to configure the SHLIB_PATH environment variable to include below directory (Path may differ for your setup).

/appl/inform/Informatica/9.0.1/server/bin

Configuring shlib_path variable will enable you to run this utility from your UNIX ID in a particular UNIX environment.

You need to execute below two commands at command prompt to configure shlib_path variable.

SHLIB_PATH=$PATH:/appl/inform/Informatica/ 9.0.1/server/bin

export SHLIB_PATH

Now your setup is ready, You can use syntax given in next step to run start workflow with this utility.

Step 4: Syntax : PMCMD Start Workflow

pmcmd startworkflow

–uv USER_TEST

–pv PASSWORD_TEST # See comments for more info on Uname/Password.

–s ITG_SERVICE

–f WF_FOLDER

–paramfile ‘\$PMROOTDIR/PARAM_FILE.TXT’

–wait WF_INFA_WF_TO_INVOKE

For easy understanding I have kept every pmcmd startworkflow parameter attributes in new line. You need to remove newline character and keep only one space before each parameter. At last your command will look like one shown in below picture.