How does Uniqe Append deal with existing data
Situation
In DATPROF Subset you can specify the deployment Strategy Unique Append.
What will be the result at the end? Which data will remain?
Explanation
What will happen is this:
We have a TARGET table with 120 records
We have updated 10 records in the TARGET Table
Of these 120 records are 10 new records, added during testing.
We have a SOURCE table with 110 records, 10 new unique records.
Then we apply the Subset Unique append strategy.
This will happen:
- All 110 records from the SOURCE table are applied
- Then the unique records from TARGET are added (To say: the 10 records added during testing)
So the updates made during testing are gone!
SOURCE |
---|
110 New |
+
TARGET INITIAL |
---|
80 Unmodified |
10 Modified |
10 Added |
=
TARGET RESULT |
---|
110 New |
10 Added |
Related articles
subset