Parameters
In a mapping, you can create two kinds of parameters, each with a different scope and purpose.
- Input Parameters
- An input parameter is a placeholder for a value or values in a mapping. Input parameters help you control the logical aspects of a data flow or to set other variables that you can use to manage different targets.
- When you define an input parameter in a mapping, you set the value of the parameter when you configure a Mapping Configuration task.
- In-Out Parameters
- An in-out parameter holds a variable value that can change each time a task runs, to handle things like incremental data loading. When you define an in-out parameter, you can set a default value in the mapping but you typically set the value at run time using an Expression transformation.
- You can also change the value in the Mapping Configuration task.