Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

When should we go for Dimension Modelling? Expand / Collapse
Author
Message
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: Wednesday, October 15, 2014 10:29 AM
Points: 2, Visits: 59
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
Post #1491174
Posted Wednesday, September 4, 2013 5:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse