Model
How a type 2 dimension grows
The problem is not how many members there are, but that a few attributes change all the time.
Worked examples, recomputed
Every number the mechanisms quote for this relationship is recomputed from it, so none of them disagrees with it.
- 5 million members × 6 changes a year → 30 million rows a year
- a type 4 mini-dimension of 5 × 4 bands → 20 rows
Where it appears
Each mechanism states it in its own names. The general symbol each name stands for is shown with it.
- Data Modeling
What does one row mean, who is allowed to change that answer, and what breaks downstream when they do?