Netezza Connector

Netezza Connector

Update as insert

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.
In the pair of values, the first two values are the primary key, for example 1 (primary key), a (primary key), 1a1. The mapping is configured to consider key constraints.

0 COMMENTS

We’d like to hear from you!