DataDriven
LearnPracticeInterviewDiscussDailyJobs

Design a Type 3 SCD for a product dimension

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

Design a Type 3 SCD for a product dimension. Keep the current category and the previous category in separate columns. This tracks one level of history without adding rows.

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