Examples of source data from a .csv file and the target tables that result from a Load Replace.
ModifiedSequence column represents a sequentially incremented value.
Target Table After
new Target Table
Log: (4 rows loaded)
2nd Load Replace
Target Table Before Load
Target Table After Load
Log: (2 rows replaced)
The Target Table has two rows with a
key column = 2.
The DW PK checkbox on the Design page has no effect on how Load Replace works.