Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

When should we go for Dimension Modelling? Expand / Collapse
Posted Wednesday, September 4, 2013 2:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 13, 2015 7:32 AM
Points: 2, Visits: 71
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,
Post #1491174
Posted Wednesday, September 4, 2013 5:05 AM



Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 15,499, Visits: 13,162
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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1491226
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse