If you use a connected Lookup transformation, you must select the

Return All Rows

multiple matches option in the lookup object properties. If you select any other option other than

Return All Rows

, the pushdown query is not generated.

For pushdown optimization to work with an unconnected lookup, select the

Report error

multiple matches option. Additionally, you must enable the

Create Temporary View

property in the session properties of the mapping task. If there are multiple matches in the data, the Secure Agent processes the records, but does not log an error when it finds multiple matches.

If there are multiple matches in the data, the Secure Agent processes the records, but does not log an error when it finds multiple matches.