ETL+ Load Replace Examples_OLD
Examples of source data and the target tables that result from a Load Replace.
Example 1
Extract, Transform and Load (ETL) page
The seq column represents a sequentially incremented value.
Design page. No PK (primary key) in target table.
Source
Target Table Before
Empty
Target Table After
Log: (4 rows loaded)
2nd Load Replace
Log: (1 rows replaced)
3rd Load Replace
1 = pre-existing row,
not changed
2 = new row
3 = replaced
Log: (2 rows replaced)
The Target Table has two rows with a row column = 2.
If the row column had been configured as a DW PK (primary key) on the Design page then the relational database referential integrity rule would have updated the existing row instead of adding a new row.