Consider the following rules and guidelines when you configure a synchronization task:
•When you use a lookup condition on a Microsoft Azure SQL Data Warehouse object and enable report error on multiple matched fields, the value is returned for any random field.
•You cannot schedule a task to run later if you use a lookup condition on a Microsoft Azure SQL Data Warehouse object.