Target Property | Description |
|---|---|
Connection | Name of the target connection. |
Target Object | Name of the target object. Select the primary target object. |
Display technical names instead of labels | Displays technical names instead of business names. |
Display source fields in alphabetical order | Displays source fields in alphabetical order instead of the order returned by the source system. |
Advanced Target Property | Description |
|---|---|
Azure Blob Container Name | Name of the container in Microsoft Azure Storage to use for staging before writing to Microsoft Azure SQL Data Warehouse. |
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 |
Update Column | The key columns to upsert data to Microsoft Azure SQL Data Warehouse. |
Number of Concurrent Connections to Blob Store | Number of threads to use to move data to the staging area in Microsoft Azure Blob Storage. Default is 4. |
Truncate Table | Truncates the target data before inserting the data to the target. This option is applicable for insert operation. |
Quote Character | Specifies the quote character to skip when you write data to Microsoft Azure SQL Data Warehouse. When you write data to Microsoft Azure SQL Data Warehouse and the source table contains the specified quote character, the task fails. Change the quote character value to a value that does not exist in the source table. |
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 |