What is the difference between SCD1 and SCD2?
1Times asked
Jul 2026Last seen
Jul 2026First seen
💡 Model Answer
SCD1 overwrites old dimension values with new ones, discarding history. It is simple and uses less storage but cannot answer historical queries. SCD2 preserves history by inserting a new row for each change, marking the previous row inactive. It requires more storage and maintenance but enables time‑based analysis. The choice depends on whether historical context is needed.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500