sm1506

• Apr 11th, 2006

 

Hi

You are supposed to define a parameter file. And then in the Parameter file, you can define two parameters, one for source and one for target.

Give like this for example:

$Src_file = c:\program files\informatica\server\bin\abc_source.txt

$tgt_file = c:\targets\abc_targets.txt

Then go and define the parameter file:

[folder_name.WF:workflow_name.ST:s_session_name]
$Src_file =c:\program files\informatica\server\bin\abc_source.txt
$tgt_file = c:\targets\abc_targets.txt

If its a relational db, you can even give an overridden sql at the session level...as a parameter. Make sure the sql is in a single line.

Prasad Parulekar

• May 14th, 2007

 

Use session parameters to make sessions more flexible. For example, you have the same type of transactional data written to two different databases, and you use the database connections TransDB1 and TransDB2 to connect to the databases. You want to use the same mapping for both tables. Instead of creating two sessions for the same mapping, you can create a database connection parameter, $DBConnectionSource, and use it as the source database connection for the session. When you create a parameter file for the session, you set $DBConnectionSource to TransDB1 and run the session. After the session completes, you set $DBConnectionSource to TransDB2 and run the session again.