When you look up data and the lookup condition finds multiple matches, the lookup returns all rows. In a mapping with Microsoft Azure Synapse SQL as target, set the

Multiple Matches

option for the lookup object to

Return all rows

. If you enabled

Multiple Matches

to any option other than

Return all rows

, the agent ignores it.

When you lookup data with null values in a Microsoft Azure Synapse SQL source and write to the target, there is a difference in the number of records in the target for a mapping that runs with and without

SQL ELT optimization

.

When you read from and write to Microsoft Azure Synapse SQL, you cannot use filters in a Lookup transformation.