Situation

In DATPROF Subset you can specify the deployment Startegy 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)

(info) 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







subset