11 Slowly Changing Dimension Type 1 (SCD 1)
Video explains - What is Slowly Changing Dimension Type 1or SCD 1 ? How to design a SCD 1 in Data Warehousing? It also explains what are Surrogate Keys and Natural Keys in Data Warehousing and how they are different ?
Chapters:
00:00 - Introduction
00:32 - What are Surrogate Keys in Data Warehousing ?
01:04 - What is Natural Key ?
01:22 - Surrogate Key with example
02:21 - What is Slowly Changing Dimension Type 1 or SCD 1 ?
02:56 - Design SCD 1 with Example
#dw #datawarehousing #slowlychangingdimension #type1 #scd1 #dw #datawarehouse #scd