Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Understand Slowly Changing Dimensions

Bryan Cafferky via YouTube

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

Reviews

Start your review of Understand Slowly Changing Dimensions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.