Learning Informatica PowerCenter 10.x - Second Edition

Defining session-level variables

The variables that are defined under session task are called session-level variables. There are various values that can be passed via variables, such as source, target data base connection value, source/target file name, source/target file path, session log file name/path, and so on. session task does most of the work in Workflow Manager screen and, hence, has been assigned special privilege. To pass the value through a variable, simply replace the hard-coded value with a variable of your choice.

As shown in the following screenshot, we are using $DBCONNECTION1 as the database connection variable:

Similarly, ...