Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

In-out parameter values

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.
A
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:
  1. Value in the parameter file
  2. Value saved from the previous task run
  3. Default value in the mapping
  4. 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.

0 COMMENTS

We’d like to hear from you!