September 4, 2013 at 2:00 am
Hi All,
Could some one explain when will the need for Dimension modelling come into picture?
And is it necessary to follow dimensional modelling even though the data warehouse size is pretty small, if so what are the advantages and disadvantages?
Thanks and Regards,
Vijay
September 4, 2013 at 5:05 am
The need for dimensional modelling typically comes when:
* you want to build a SSAS cube on top of the data warehouse (as SSAS thinks in terms of facts and dimensions).
* business users need to create reports directly on top of the database. Dimensional modelling is generally easier to understand than a fully normalized model
* you want to store historical data efficiently
You don't need to use dimensional modelling, you can also use for example the Inmon methodology.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply