DRAFT ETL+ Load Replace Example -- Duplicate key in Source & PK on Source Field/Watermark
Examples of source data and the target tables that result from a Load Replace.
Configurations
The ‘watermark’ field, ModifiedSequence, is also the DW PK (see Design page).
ModifiedSequence column make a PK
The ModifiedSequence column represents a sequentially incremented value.
Initial Load
Source file
Target Table After
ETL+ Preview Table
Log: (4 rows loaded)
SSMS display. ModifiedSequence is given a index.