Netezza Connector

Back Next

Update else insert

When you configure the mapping to update else insert rows, the Secure Agent uses the following process to update target rows:

If the source key value matches a target key value, the Secure Agent updates each
target row. It updates with the first or last source row matched, based on how you configure duplicate row handling.

If the source primary key value does not exist in the target, the Secure Agent inserts the source row.

The following table describes how the Secure Agent updates the target:

Source Data	Target Data	Updated Target Data	Comment
1,2	1,6	1,2	Updates 1,6 with 1,2. The source primary key is found in the target. The target row is updated based on duplicate row handling to use first row.
1,3	1,8	1,2	Updates 1,8 with 1,2. Duplicate row handling is configured to update with first source row. Subsequent target rows with primary key “1” are updated with first source row.
2,4	-	2,4	Inserts 2,4. The source primary key is not found in the target. The row is inserted.
2,5	-	-	Drops 2,5. The source primary key is found in the target, and first duplicate row has been updated in the target.
-	3,7	3,7	Retains 3,7. No update required.
In the pair of values, the first value is the primary key, for example 1 (primary key), 2.

Rename Saved Search

Table of Contents

Netezza Connector

Netezza Connector

Update else insert

Update else insert