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.