Mappings

Back Next

In-out parameter values

An in-out parameter is a placeholder for a value or values that the task applies at run time. You define the value of the in-out parameter in the mapping and you can edit the value when you configure the

mapping

task.

mapping

task uses the following values to evaluate the in-out parameter at run time:

Default Value. The value specified in the in-out parameter configuration.

Value. The current value of the parameter as the task progresses. When a task starts, the value is the same as the default value. As the task progresses, the task calculates the value using a function that you set for the parameter. The task evaluates the value as each row passes through the mapping. Unlike the default value, the value can change. The task saves the final value in the job details after the task runs.

If the task does not use a function to calculate the value of an in-out parameter, the task saves the default value of the parameter as the initial current value.

An in-out parameter value cannot exceed 4000 characters.

At run time, the

mapping

task looks for the value in one of these locations, in the following order:

Value in the parameter file

Value saved from the previous task run

Default value in the mapping

Default value for the data type

If you want to override a saved value, define a value for the in-out parameter in a parameter file. The task uses the value in the parameter file.

In-out parameters

Download Guide

Watch