Рет қаралды 234,817
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