How does Uniqe Append deal with existing data

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!

+

=