Implementing SCD Type 2 Changes

Slowly Changing Dimensions (SCD) Type 2 keep record of historic changes to dimension records. A typical data load process would has to read new dimension records, identify the changes, and either insert new records or update existing records as appropriate.

In this exercise, we'll go through a Power Query template demonstrating a sample implementation of SCD Type 2 to understand all the steps involved.

Note: If you get an error about an API rate limit, this usually happens because a previous Fabric task has not completed. You can view active Fabric tasks from the Monitor page (located on the left vertical menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.