Enabling array update and upsert operations for an Oracle target
Enabling array update and upsert operations for an Oracle target
You can configure an Oracle mapping to update or upsert data in batches of arrays.
When you configure an array update or upsert, the Secure Agent clubs all records together into arrays and writes those arrays of data into the Oracle target in batches instead of updating or upserting data row by row. Array update and upsert operations reduce the network traffic and optimizes performance.
To configure an array update or upsert, you must set the following custom properties:
EnableArrayUpsert
Before you upsert data into an Oracle target, configure the
EnableArrayUpsert
custom property in the Secure Agent properties or in the Oracle
mapping
task properties, and set its value to yes.
EnableArrayUpdate
Before you update data into an Oracle target, configure the
EnableArrayUpdate
custom property in the Secure Agent properties or in the Oracle mapping task properties, and set its value to yes.
You cannot array update or upsert data to an Oracle target when you select the data driven operation in an Oracle target transformation.