Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn about Slowly Changing Dimensions (SCDs) in data warehouse architecture through a comprehensive 23-minute lesson. Explore the concept of SCDs, their importance in star schema design, and various SCD types including "Do Nothing," "Maintain History," and "Keep Limited History." Gain insights into handling this crucial aspect of data warehousing, preparing you to confidently answer related interview questions and implement effective solutions in your projects. Delve into additional SCD types and wrap up with a solid understanding of this pivotal data warehousing concept.
Syllabus
Intro
Where Are We Going?
Star Schema
What are slowly changing dimensions?
Do Nothing
Maintain History
Keep Limited History
Other SCD Types
Wrapping Up
Taught by
Bryan Cafferky