Netezza target data update

Update as insert

When you configure the mapping to update as 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 does not insert the source row.

•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,a,1a1	-	-	The source primary key is found in the target. The row is not inserted.
1,b,1b1	-	1,b,1b1	Inserts 1,b,1b1.
1,a,1a2	-	-	The source primary key is found in the target. The row is not inserted.
1,c,1c1	1,c,1c1	1,c,1c1	The source primary key is found in the target. The existing row 1,c,1c1 is retained. No insert is required.
1,d,1d1	-	1,d,1d1	Inserts 1,d,1d1.
1,a,1a3	1,a,1a3	1,a,1a3	The source primary key is found in the target. The existing row 1,a,1a3 is retained. No insert is required.

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.