Slowly Changing Dimensions

• Tags:: 📝CuratedNotes, Data Modeling

From 📖 The Data Warehouse Toolkit 3rd Edition:

To this point, we have pretended dimensions are independent of time. Unfortunately, this is not the case in the real world. Although dimension table attributes are relatively static, they aren’t fixed forever; attribute values change, albeit rather slowly, over time. (p. 148)

Link to original