Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2008-11-24 : 02:14:02
|
| Hi pals,I just want to know the basic difference between a Aggregate Tables and typical STAR Schema? In some implementations , they are using all Aggregate Tables and in another implementation they are using STAR Schema ( Dimensions and Facts). Basically i am an SSIS package developer. I just want to understand under which circumstances we go for Aggregate tables and STAR Schema.Few Questions on this area --------------------------------Is there any advantage in Reporting?There is no need to create a CUBE if we go for Aggregate Table?Does it depends on size of data to pick either of the 2?Does it totally depends on Client Requirement.Just Curious!Any suggestions would be greatly appreciated.Thanks in Advance.Franky. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-11-24 : 10:07:51
|
| Those are complex questions that are difficult to answer without knowing the specifics of an application.You would be better off reading a book on this subject to understand what it is all about.http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball and Margy RossCODO ERGO SUM |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-11-27 : 08:01:27
|
| Thank You! |
|
|
|
|
|
|
Dimensional Modelling!