Microsoft Azure SQL Data Warehouse Lookup in Mapping Tasks
When you configure field mappings in a mapping task, you can create a lookup to a Microsoft Azure SQL Data Warehouse object. When you use a Microsoft Azure SQL Data Warehouse object as a lookup, you do not need to configure specific Microsoft Azure SQL Data Warehouse properties.