Slowly changing type 2 dimensions are typical in data warehouses. This enables historical tracking of attributes in a dimensional model. Power BI does not need a special indicator for this, just good modeling at the dimension and fact levels. Data Factory is the ETL/ELT tool used with Azure data services. Azure Synapse uses the same interface for pipelines. The slowly changing dimensions pattern is required for anyone integrating source data into a data mart. This session will demo a technique for implementing a pipeline for tracking historical changes in a dimension table.
You will learn:
- What is Synapse
- External table on blob storage
- Understanding the levels of a Modern Data Warehouse - Bronze, Silver and Gold