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+ Preview page

 

From SSMS

ETL Log: (4 rows loaded)

2nd Load Upsert

Data Source

Target Table Before 2nd Upsert

Target Table After 2nd Upsert

1st row updated with
Sequence = 105

 

Highwater level = 104
Upsert rows where
Sequence >= 104

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.

Â