INFO:

The video explains what are slowly changing dimensions, Their relevance in data warehousing and which SCD type should be used in what kind of data scenario. The video Explains below with real project examples. #SlowlyChangingDimension #SCD2 #TechCoach SCD 0 - Passive method (No change in data) SCD 1 – Overwriting the old value (Latest Record Only) SCD 2 – Creating a new additional record (Maintains History) SCD 3 – Creating an additional Column (Rarely Used) SCD 4 – Using history table SCD 6 - The hybrid approach