When you configure a lookup, you define the behavior when a lookup condition returns more than one match. You can return all rows, any row, the first row, the last row, or an error.
The following configurations have multiple match policy restrictions:
You cannot parameterize an uncached connected lookup with parameterized prefixes at source.
When the data is not matched for an uncached connected lookup, incorrect data is logged in the target.