Examples of source data and the target tables that result from a Load Replace.Key point: The so called DW PK column in the Design page does not put a PK in the target table!
Load Replace requires that at least one column be designated as a DW PK on the Design page.
Target Table After
new Target Table
Log: (4 rows loaded)
Target Table Before Load
Target Table After Load
Log: (2 rows replaced)
The result above – 2 rows with the same PK – would not be allowed if the ETL+ created the target table with the PK as designated on the Design page.