Parameters tab

This tab allows you to define or pass variables and/or parameters to the job. If multiple rows are passed to the job, the first row can be used to set the parameters or variables.
For each variable or parameter name that is added to table, you must assign a value to that parameter in either the Variable / Parameter to use field or the Static input value field. You cannot use both a variable and a static value.
Option
Description
Variable / Parameter name
Specify the name of the variable or parameter.
Variable / Parameter to use
The Variable / Parameter to use column is for setting the names of variables and/or parameters that are defined and passed to the child transformation.For this column, enter a value using one of the following methods:
Select an incoming field using the drop-down menu.
Manually enter a variable name.
Use CTRL SPACE to select a value from a list of PDI environment variables.
If you specify a field or value in Variable / Parameter to use, the Static input value column is disabled.When the Variable / Parameter to use contains a valid value, the Inherit all variables from transformation check box does not affect the Variable/Parameter to use.
Static input value
Instead of a field, specify a static value to use.Entering a value in the Static input value field disables the Variable / Parameter to use field.
Inherit all variables from transformation
When this check box is selected, all the variables defined in the parent transformation are passed to the child transformation.
Get Parameters
Click this option to insert all the defined parameters of the specified transformation. The description of the parameter is inserted into the static input value field.
Last updated
Was this helpful?