|
|
|
PARAMETERS & VARIABLES |
| |
Why we have to create Mapping Parameters or Variables ?
you can use mapping parameters and variables to make mappings more flexible.
You can Reuse a mapping by varing the parameters and Variables.
Represntation
$$parametername/$$variablename
Parameters |
A mapping parameter represents a constant value that you can define before running a session. A mapping parameter retains the same value throughout the entire session.
Variables
| A mapping variable represents a value that can change through the session. The PowerCenter Server saves the value of a mapping variable to the repository at the end of each successful session run and uses that value the next time you run the session. |
Default Values of Mapping Parameter and Variables
| Data |
Default Value |
| String |
Empty String |
| Numeric |
0 |
| Datetime |
1/1/1753 A.D. , |
|
|
