Outrigger and Mini-Dimensions

The interviewer will push back on your dimension design: 'This dimension has 50 columns and half of them change weekly. How do you handle that?' This tests whether you know the mini-dimension pattern. Candidates who say 'just apply Type 2 to everything' reveal they have never calculated the storage cost of that approach. The Problem the Interviewer Describes State the problem with numbers: 'A dim_customer with 50 columns, 12 of which change weekly. With Type 2 on all 12, that is 10 million customers times 3 weekly changes times 50 weeks: 1.5 billion rows per year. The dimension becomes unjoinable.' The interviewer is checking whether you can calculate the storage cost of a design decision before committing to it. 1.5B Mini-Dimensions: The Answer That Shows You Know Kimball Your mini-dimens