ETL+ Load Upsert

Efficient updating of large tables with the upsert delta load type.

Requires the source table has a unique key.

Load Upsert option in Load panel.
The Key+ checkboxes on the Design page designates the unique key.

Select Load to open the Design page.

Design page. Here Source_key is designated as the Key+ key.

In this section

ETL+ Load Upsert Example 1 — Example of Upsert in action. A simple example that shows how Upsert works with a few rows and columns of data.

ETL+ Load Upsert Example 2 — Simple Upsert example. No deleted source records, no changes to key.

ETL+ Upsert Concepts & Logic — Upsert refers to the process of inserting new data or updating existing data in a target (data warehouse) table based on matching criteria. The term "Upsert" is a combination of "Update" and "Insert". The limitation of Upsert is that it does not Delete old records.

Related Pages

ETL+ Design Page

Search: Upsert,

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

If this problem persists, please contact our support.