DRAFT ETL+ Load Replace Example – .CSV Source
Examples of source data from a .csv file and the target tables that result from a Load Replace.
Example 1

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
new Target Table

SSMS
Log: (4 rows loaded)
2nd Load Replace
Source file
Target Table Before Load
Target Table After Load

Row2 updated, ModifiedSequence = 105

The Primary Key (PK) is ModifiedSequence

Table has two rows where the row column = 2.
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.