In this example we will run an extraction to merge data, i.e. insert a new data row or update an existing one.
Prerequisite for executing the merge is defining a primary key in the General Settings of the extraction.
Now let’s change the Destination settings of the extraction and set
Preparation to Prepare Merge
Row Processing to Fill merge staging table
Finalization to Finalize Merge
to merge the data.
The Prepare Merge statement creates a temporary staging table on the database.
In the Row Processing the staging table is filled.
The Finalize Merge statement inserts new data rows and updates an existing ones.
Afterwards the staging table created in the Preparation step will be deleted.