Data Warehousing – Star Schema vs Flat Table
Your question is very good: the Kimball mantra for dimensional modelling is to improve performance and to improve usability. But I don’t think it is outdated, or dogma- it is a reasonable, practical approach for many situations and platforms. The way relational DBs store data means there’s a balancing act to be struck between the … Read more