Cloud Data Integration Connectors All Products
When you use multiple instances of a Microsoft Azure SQL Data Warehouse V3 connection and perform same operation to write data to multiple instances of the same target, the mapping fails abruptly.
When you run a mapping that reads data from a storage system source and you select
Create Targetto write data to a Microsoft Azure SQL Data Warehouse target, the columns are created with the NOT NULL constraint in the target table. The null values from the source are not written to the target and the mapping fails.
When you run a mapping that reads data from a Microsoft Azure SQL Data Warehouse source, writes data to multiple Microsoft Azure SQL Data Warehouse targets, uses DATA DRIVEN for both targets, and the batch sizes defined for both targets are different, the mapping stops responding.