Table of Contents

Search

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

Mappings

Mappings

Using in-out parameters as expression variables

Using in-out parameters as expression variables

In a non-elastic mapping, you can use an in-out parameter as a placeholder for an expression. To use an in-out parameter as an expression, create a string parameter and enable the
Is expression variable
option. You cannot use an in-out parameter as an expression in an elastic mapping.
When you enable this option,
Data Integration
resolves the parameter as an expression. When you disable this option, Data Integration resolves the parameter as a literal string.
You can use an in-out parameter as an expression variable in the following transformations:
  • Expression
  • Filter
  • Aggregator
  • Router
You can override the parameter at runtime with a value specified in a parameter file.
  1. In the mapping, create an in-out parameter.
  2. Configure the parameter properties.
  3. Set the data type to String or Text.
  4. Enable the
    Is expression variable
    option.
  5. Use the parameter as an expression.
  6. Optionally, you can override the default value of the parameter in one of the following places:
    • On the
      In-Out Parameters
      tab of the task.
    • In a parameter file. Enter the parameter file name and location on the
      Schedule
      tab of the task.
When the task runs,
Data Integration
resolves the parameter as an expression.