Skip to content

Data Engineering with Salim Saeedi

AWS and Azure Musings

  • About

Month: December 2020

Using MERGE for SCD Type 2 with multiple updates

December 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 Leave a comment

Dynamic 365 Audit History Export through Power BI

December 18, 2020 by admin

Dynamic 365 provides an Audit History in all pages. In case you need to export these data or have a query to the data, Dynamics API provides this access. In Power BI, OData Feed enables this access. In order to achieve this: Use OData source and point it to “audits” entity. Refer to Microsoft’s Web … Read more

Categories Tutorial Tags audit history, audit log, dynamics, export, Power BI Leave a comment

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
    © 2023 Data Engineering with Salim Saeedi • Built with GeneratePress