By default, when a lookup condition returns multiple matches, the task returns an error.
You can also configure the task to return a random row.
For each lookup source, configure how the task handles multiple return values. You can
select the following multiplicity options:
Error if more than 1 output
value. The task displays an error. Data Integration rejects rows when multiple
matches are found and writes them to the error rows file. This is the
default.
Randomly pick 1 output value.
The task chooses the first returned value. Different systems might use different
orders to return lookup values.
ASK INFAPreview
