A parameter is a constant value that you can change between mapping runs.
In a dynamic mapping, you can use parameters to change sources and targets. You can also use parameters for input rules, selection rules, run-time links, and transformation properties. When you change the value of the parameter, the Data Integration Service creates or recreates the target according to the value specified in the parameter.
Right-click in the editor and select
Add Transformation
.
Select Write from the list of transformations, and then click
OK
.
Type the first letter of the transformation to filter the list.
The New Write Transformation dialog box opens.
Select
Create using a parameter
.
Browse to select the parameter, or click
New
to create a new parameter, and then browse to select a data object to create the parameter from.
Optionally, select the option
At run time, get data object columns from data source
to refresh the transformation columns at run time.