You can enable bulk processing to write large amounts of data to Amazon Redshift. Bulk processing utilizes minimal number of API calls and enhances performance of the write operation.
To enable bulk processing, specify the property
-DENABLE_WRITER_BULK_PROCESSING=true
in the Secure Agent properties:
Perform the following steps to configure bulk processing before you run a mapping:
In Administrator, select the Secure Agent listed on the
Runtime Environments
tab.
Click
Edit
.
In the
System Configuration Details
section, select
Data Integration Service
as the service and
DTM
as the type.
Edit the
JVMOption1
property, and enter
-DENABLE_WRITER_BULK_PROCESSING=true
.
Click
Save
.
Not applicable to mapping tasks configured with pushdown optimization.
ASK INFAPreview
