Skip to main content
Skip table of contents

How does Uniqe Append deal with existing data

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.