briefly discuss what happens in a Type 3 slowly changing dimension (SCD) when a corresponding data record is updated in the transaction processing system
briefly discuss what happens in a Type 3 slowly changing dimension (SCD) when a corresponding data record is updated in the transaction processing system
Slowly Changing Dimension:-
You link fact records to a particular dimension record with its associated attributes when organising a data warehouse into Kimball-style star schemas. However, what if the data in the dimension changes? Do you now link the updated value to every fact record? Do you refuse to make the adjustment to maintain historical accuracy? Or do you handle prior to the dimension shift facts differently than subsequent ones?
This choice will affect if your dimension is a slowly evolving one. Depending on how you handle incoming change, there are various sorts of SCD.
Step by step
Solved in 2 steps
