Advanced Property | Description |
|---|---|
Start Date | Start date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ. To perform a full read, do not use the Start Date and End Date properties. |
End Date | End date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ. To perform a full read, do not use the Start Date and End Date properties. |
Page Size | Page size used to get data from a source. Default is 100 rows. |
Get Deleted | Includes records that were deleted between the start date and end date for changed data capture. |
Advanced Property | Description |
|---|---|
Replace All | Removes existing data from the child object before writing new data to the target. |
Batch Size | Number of rows that the agent writes in a batch to the target. When batch size is 0, the agent writes data to the target one row at a time. When batch size is greater than 0, the agent writes data to the target in batches of the specified size. |
Success File | Name of the file that contains rows successfully written to the target. |
Reject File | Name of the file that contains rows that were not written to the target. |
Success File Directory | Directory for the success log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the success log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\success |
Error File Directory | Directory for the error log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the error log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\error |