Data Integration Connectors
- Data Integration Connectors
- All Products
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.
|