Database Reference
In-Depth Information
Defining mapping-level variables
As mentioned earlier, you can define variables for the hardcoded values in the mapping in-
side transformations as well. You need to define parameters or variables under
Mapping
before you can use them in transformations, otherwise the mapping will become invalid. To
add the value, perform the following steps:
1. Open the mapping for which you wish to add variables in Mapping Designer, and
navigate to
Mappings
|
Parameters and Variables
.
2. In the next screen, click on
Add a new variable to this table
. Define the variable
as
select the type as Parameter and Variable
based on your requirement. Now,
click on
OK
.