DRAFT ETL+ Load Replace Example 2 - Primary Key Prevents Duplicates?

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!

Example Configurations

Load Replace requires that at least one column be designated as a DW PK on the Design page.

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 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.