Learning Informatica PowerCenter 10.x - Second Edition

Defining mapping-level variables

As mentioned earlier, you can define the variable for the hardcoded values in mapping inside transformations also. You need to define parameters or variables under mapping before you can use them in transformations, else the mapping will become invalid. To add the values, perform the following steps:

1. Open the mapping for which you wish to add variables in the Mapping Designer, go to Mappings | Parameters and Variables:
   
2. In the next screen, click on Add a new variable to this table. Define the variable, and select the type as Parameter and Variable based on your requirement. Click on OK:

As you can notice, ...