Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.