What is a 'Slowly Changing Dimension Type 0'?
What is a 'Slowly Changing Dimension Type 0'?
Approach: Explain the fixed nature of Type 0.
A dimension attribute that never changes once it is set. The original value is preserved forever (e.g., an original customer start date).
Follow-up: What is SCD Type 1?
Key concepts: immutable, original value.