title: MERGE (UPSERT) - AZURE SQL DWH
body: <p>I been working long with on-premises DWH solutions.  Now moving to AZURE DWH.</p>
  
  <p>Right now am up-to doing most of the processing / transformation in Azure Databricks and writing the result set to Azure SQL DWH Staging Tables.</p>
  
  <p>Now I want to MERGE (UPSERT) the Dimensions and Load Fact Tables.</p>
  
  <p>As MERGE is not supported in AZURE SQL DWH, what is the best way to accomplish this?</p>