Mappings

Back Next

Using in-out parameters as expression variables

Configure an in-out parameter as an expression variable and use it to parameterize expressions or user-defined functions. To use an in-out parameter as an expression variable, create a string parameter and enable the

Is expression variable

option.

You can't use an in-out parameter as an expression variable in advanced mode.

When you enable

Is expression variable

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:

Aggregator

Expression

Filter

Router

You can override the parameter at runtime with a value specified in a parameter file.

In the mapping, create an in-out parameter.

Configure the parameter properties.

Set the data type to String or Text.

Enable the

Is expression variable

option.

Use the parameter as an expression or user-defined function.

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.

In-out parameters

Download Guide

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Mappings

Mappings

Using in-out parameters as expression variables

Using in-out parameters as expression variables