Property | Description |
|---|---|
Connection | Name of the target connection. |
Target Type | Target type. Select one of the following target types:
|
Object | Name of the target object. |
Operation | Select Insert or Delete or Upsert. |
Advanced Property | Description |
|---|---|
Azure Blob Container Name | Microsoft Azure Storage container name. |
Field Delimiter | Character used to separate fields in the file. Default is 0x1e. You can select the following field delimiters from the list: ~ ` | . TAB 0x1e |
Number of Concurrent Connections to Blob Storage | Number of threads to use to move data to the staging area in Microsoft Azure Blob Storage. Default is 4. |
Truncate Table | For insert operations. Truncates the target before inserting data to the target. |
Update Column | The key columns to upsert data to Microsoft Azure SQL Data Warehouse. |
Success File Directory | Directory for the success file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the success file to the following directory:<Secure Agent installation directory>/apps/Data_Integration_Server/data/success |
Error File Directory | Directory for the error rows file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the error rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/error |
Forward Rejected Rows | Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task forwards rejected rows to the next transformation. |