ETL+ Load Upsert Example 1 With 'Force Replace with Upsert'

Example of loading a loading table regularly serviced with Upsert with Load Replace. example. Shows how the Load Replace processes deleted source records.
🛠️ Work in progress

Load Upsert does not delete records. Load Replace does. This examples shows the results of a Upsert followed by a Replace. This example follows the Upsert example at ETL+ Load Upsert Example 1 .

^NOTE: The Load type on the Job page supports periodically running Load Replace and Load All on tables. The support for Replace is the Force Replace with Upsert, default for others option on Load type.

Most Recent Load Upsert

Continued from ETL+ Load Upsert Example 1

Periodically Refresh with Load Replace

The Force Replace with Upsert option on the Job Page supports periodically loading the Load Upsert table with Load Replace.

🛠️ Screenshots

Rough examples work in progress