07 April 2012

Data Warehouse - Dimensional Modeling Myths

* Dimensional models and data marts are for summary data only
* Dimensional models and data marts are departmental, not enterprise solutions
* Dimensional models and data marts are not scalable
* Dimensional models and data marts are only appropriate when there is a predictable usage pattern
* Dimensional models and data marts can’t be integrated and therefore lead to stovepipe solutions