Using Merge

Use the instructions in this procedure to use Merge for executing tables.

Currently, DWD uses UPDATE and INSERT queries independently in order to update existing rows and insert new rows to tables.

DWD can now use the Microsoft SQL Server Merge function to update existing records and insert new ones in the data warehouse. The Merge function performs insert and update operations on a target table based on the results of one or more source tables. .

Note: 

The Merge function will be used when the append new rows option of the ETL Processing overview is selected. A full refresh will not use the Merge function.

Follow the instructions below to use Merge for executing tables.

Use Merge

  1. In the DWD Designer, navigate to Compile > Compilation Options.
  2. Check Use Merge.
  3. Click OK to save the settings.

    This enables DWD to use the Merge function when executing tables.

  4. Compile all tables where you want the Merge function to be applied.
    Note: 

    You must compile all tables. The statements are only prepared during compilation.

  5. Execute.