Browsed by
Category: SCD

Hierarchical data with SCD Type 2

Hierarchical data with SCD Type 2

The question that is always asked with storing data with Slowly Changing Dimensions, is to what extent you want to keep the historical data. I would like to explain a situation of hierarchical data that is stored with the SCD method and how this affects the data. As an example where I first got in touch with this subject, I’ll take the hierarchical relationship between employees and managers. The employees’ data is stored as SCD Type 2, and this table…

Read More Read More