When you perform an insert operation, the Secure Agent inserts and updates the entries in the target table based on the source key value and target key value match. The matching criteria for insert operation is

_id

.

When you perform an update operation, you can select update columns only with primitive data types.

When you perform an update or delete operation, the

_id

column in the target table is considered as a key column along with the other update columns selected.

When you create a new target at run time and the target already exists, the mapping updates the data to the existing target when you perform an update operation and deletes the data from the existing target when you perform a delete operation.

To perform an upsert operation on the target, set the update mode to

Update Else Insert

in the Target transformation.

To perform a Data Driven operation on the target, specify a column in the

Update Columns

field even if you defined a primary key in the target table.

When you override the parameterized target object at run time in a mapping, you can't perform the Data Driven operation on the target object.