Tasks

Back Next

Lookup return values

When you configure a lookup, you configure a lookup return value. The lookup return value depends on the return value properties that you define, such as multiplicity or a lookup expression.

A lookup return value is the value that

Data Integration

returns when it finds a match based on the lookup condition. If the lookup returns an error,

Data Integration

writes the row to the error rows file.

You can configure a lookup expression as part of the lookup return value. Configure a simple expression that uses the $OutputField variable to represent the lookup return value.

For example, the following expression adds 100 to each lookup return value:

$OutputField+100

As another example, you can use the concatenate operator ( || ) to append a string to a string lookup return value as follows:

'Mighty' || '$OutputField'

You can use parameters defined in a parameter file in a lookup expression.

The following table describes the lookup return value properties that you can configure:

Lookup Return Value Property	Description
Output Field	The field from the lookup table that you want to use.
Multiplicity	How Data Integration handles multiple return values. Error If More Than 1 Output Value. Select if the synchronization task should display an error when the lookup condition returns multiple values. Data Integration rejects rows when multiple matches are found, writing them to the error rows file. This is the default. Randomly Pick 1 Output Value. Select if the synchronization task should choose the first returned value when a lookup condition returns multiple values. Different systems might use different orders to return lookup values.
Expression	A simple expression that uses $OutputField to represent the selected output field. By default, Data Integration passes the lookup return value without alteration with the following expression: $OutputField.