Saturday 22 December 2012

Using Multiple Parameter Files In A Single Informatica Session

Multiple Parameters are used mostly for executing concurrent workflows. While implementing concurrent execution of workflows you need to enable option “Configure Concurrent Execution”. Each parameter file will contain different file names and when we execute the workflows concurrently it picks different files which are defined in different parameter files and loads data concurrently. This method will improve the performance of Informatica sessions by using parallelism.

For example consider that you are using three parameter files for three separate files(File1,File2 and File3) then you need to define the parameter file as below

Parameter File 1
$InputFileName = "File1"
Parameter File 2
$InputFileName = "File2"
Parameter File 3
$InputFileName = "File3"

Experts please share your opinion on this……

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis