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 |
|
amex45
Starting Member
16 Posts |
 Posted - 2004-01-28 : 20:24:32
|
| How do we decide which schema to pickup for your dimensions? The only difference is the physical implementation. Snowflake schema more normalized. Star schema is easier for direct access. Is this the only difference? If so why don’t we MS take Snowflake totally out of Analysis services?Thanks |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-01-30 : 20:00:35
|
| I've just done the MS DTS course and the tutor on that suggested that you don't need the snowflake as you can do it all in staging and so improve performance on your cubes.steveSteve no function beer well without |
 |
|
|
|
|
|
Star or Snowflake???