Paths/Data Engineer/Modeling & Warehousing / Dimensional Modelling
Handle Changing Dimensions
A customer moves, a product is repriced - and yesterday's report must not change. Document the Type 2 pattern that keeps history intact.
Validator
⏱ 0:00
IDLE — checks run live as you type commands; submit when done
01Requirements
live checks- File ~/warehouse/model/scd.md exists○
- The document describes the Type 2 approach○
- The document names the effective date columns○
- The document explains how the current row is found○
02Walkthrough
1 of 4 revealed- 01
Write the heading
Start with the decision - which type of slowly changing dimension you chose and why.
echo '# Slowly changing dimensions\n\n## Type 2 - keep the history\n\nEvery change closes the old row and opens a new one.' > ~/warehouse/model/scd.md - 3 locked · each failed submit reveals one
03Stuck?
0 of 3 revealedTake a hint without losing the lab — each one points at the thing to look at, not at the answer.
04AI Tutor
guides, never solvesTell me what you're stuck on — I'll nudge, not solve. Which requirement are you looking at?
04Notebook
saved locally in this browserlearner@lab — ubuntu:24.04
Session is disposable
↑/↓ recalls commands · Ctrl+Enter submits · type help for the command list