ETL+ Load Upsert Example 1
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.
