DataDriven
LearnPracticeInterviewDiscussDailyJobs

Create a hybrid SCD for customers: use Type 2 for location changes (new rows) and Type 1 for contact

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain
Data Modeling
Difficulty
medium

Problem

Create a hybrid SCD for customers: use Type 2 for location changes (new rows) and Type 1 for contact info updates (overwrite).

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • Data Modeling Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons