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 |
|
nabruphonic
Starting Member
2 Posts |
 Posted - 2009-03-27 : 08:23:47
|
| Hi @all!I am new in MS SQL Server 2008.I want to realize a Data Warehouse. Furthermore I want to realize it with a relational scheme (a Fact Constellation).Can I use SQL Server Management Studio to create the scheme and use afterall Analysis Services to create my Dimensions and a Cube?For my aim it is better to have a relational structure than a multidimensional one.Thanks a lot! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-28 : 03:35:39
|
| yup...you should create the dimensions, facts etc in the relational db using sql mgmnt studio. then you should build the cube in your analysis server from these facts and dimensions by setting up correct relationships. |
 |
|
|
nabruphonic
Starting Member
2 Posts |
Posted - 2009-03-30 : 02:14:54
|
| Thanks a lot! |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-03-30 : 12:08:16
|
| Fact and dimension tables are for datamarts, not data warehouses.You can't build a data warehouse with fact and dimension tables.Build a normalized data warehouse, then create datamarts for subsets of the data as necessary.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
Data Warehouse with Relational Scheme