About this document
Understanding Slowly Changing Dimensions by Asad Hussain is a document available to read on EtoBox.
Slowly changing dimensions refer to how changes in source data are reflected in dimension tables in a data warehouse. There are three types: type 1 overwrites data, losing history; type 2 adds a new row preserving history; type 3 uses attribute pairs to track both current and previous values. The document provides examples and explanations of each type and how they affect the ability to analyze historical facts.
- Author
- Asad Hussain
- Language
- EN