ETL+ Load Upsert Example 1

Owned by Cortlandt _
Oct 06, 2023
2 min read

 

ETL Configuration

Sequence is the highwater column

Initial Load Upsert

Data Source

Target Table After Initial Load Upsert

 

ETL Log: (4 rows loaded)

2nd Load Upsert

Data Source

Target Table Before 2nd Upsert

Target Table After 2nd Upsert

 

ETL Log: (2 rows upserted)

 

Target Table in Data Warehouse (SSMS)

Included for those interested. Very few users need to know the internals of the database tables storing the data warehouse.

Â