Session

Using Azure Data Factory (ADF) to Load a Slowly Changing Dimension table

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.

Thomas LeBlanc

Data Warehouse Architect/MVP at Data on the Geaux

Baton Rouge, Louisiana, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top