ETL+ Load Replace Example -- PK on Source Field/Watermark
Examples of source data and the target tables that result from a Load Replace.
Example 1
The ‘watermark’ field,
ModifiedSequence, is also the DW PK (see Design page).
The ModifiedSequence column represents a sequentially incremented value.
Initial Load
Source file
Target Table After
new Target Table
Log: (4 rows loaded)
2nd Load Replace
Source file
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.