Skip to content

Data Engineering with Salim Saeedi

AWS and Azure Musings

  • About

MERGE

Using MERGE for SCD Type 2 with multiple updates

February 4, 2023December 24, 2020 by admin

Below is the typical MERGE statement for SCD Type 2: Since a MERGE statement cannot update more than one match at a time, in scenarios which the source contains historical data that for each matching key (per ON statament) may need more than 1 action in a single merge statement run (e.g. one INSERT and … Read more

Categories Tutorial Tags MERGE, scd, slowly changing dimension, SQL

Recent Posts

  • Databricks not recognizing updated Service Principal Secret
  • Inline Try-Catch for Azure Data Factory activity output
  • Using MERGE for SCD Type 2 with multiple updates
  • Dynamic 365 Audit History Export through Power BI
  • Pipenv dependency resolution procedure

Recent Comments

    Archives

    • August 2022
    • March 2021
    • December 2020
    • May 2020
    • January 2020

    Categories

    • Tutorial
    © 2025 Data Engineering with Salim Saeedi • Built with GeneratePress