Friday, 4 November 2016

Using Both Informatica Workflow Parameter File and Session Parameter File Together

The only way I know is to use a workflow parameter file and a session parameter file.

 

By default, when you define a workflow parameter file and a session parameter file for a session within the workflow, the Integration Service uses the workflow parameter file, and ignores the session parameter file.

 

You can force the workflow to use both the workflow parameter file and session parameter file by adding the following to the workflow section of the workflow parameter file:

 

    $PMMergeSessParamFile=TRUE

 

This must be set for the section defined for the workflow in the workflow parameter file.

 

Example

    [DEV_FOLDER.wf_workflow]

    $PMMergeSessParamFile=TRUE

 

Note

If you define the same parameter or variable in both the session and workflow parameter files, the Integration Service sets parameter and variable values according to the following rules:

 

  1. When a parameter or variable is defined in the same section of the workflow and session parameter files, the Integration Service uses the value in the workflow parameter file.
  2. When a parameter or variable is defined in both the session section of the session parameter file and the workflow section of the workflow parameter file, the Integration Service uses the value in the session parameter file.

No comments:

Post a Comment