Property | Description |
|---|---|
Connection | Name of the target connection. |
Target Type | Type of the target object. Select Single Object or Parameter. |
Object | Name of the target object for mapping. |
Operation | Target operation. Select Insert, Update, Upsert, or Delete. |
Advanced Property | Description |
|---|---|
Maximum Batch Size | Determines the maximum number of records the Secure Agent can write at a time during bulk load of data. Default is 50. |
Thread Count | Number of parallel threads for data load. Set the appropriate value based on the hardware capabilities of the machine on which the Secure Agent runs. Default is 8. Thread count is not applicable for bulk. |
Use Bulk | Writes records in bulk mode during data load. By default, the Secure Agent does not write records in bulk mode during data load. |
Alternate Key Name | Indicates whether the column is an alternate key for an entity. Specify the name of the alternate key. You can use alternate key in update and upsert operations. Note: You must specify the name of the alternate key, not the field. Note: If you map both primary key and alternate key attributes in a mapping, the primary key takes precedence over the alternate key. |
Success File Directory | Directory where the Secure Agent stores the success log files. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, the Secure Agent writes the success log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\success |
Error File Directory | Directory where the Secure Agent stores the error log files. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, the Secure Agent writes the error log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\error |
Forward Rejected Rows | Forwards rejected rows to the next transformation. |