Building a Data Warehouse
Posted
by Paul
on Server Fault
See other posts from Server Fault
or by Paul
Published on 2010-04-15T17:32:25Z
Indexed on
2010/04/15
17:33 UTC
Read the original article
Hit count: 321
I've seen tutorials articles and posts on how to build datawarehouses with star and snowflakes schemas, denormalization of OLTP databases fact and dimension tables and so on.
Also seen comments like:
Star schemas are for datamarts, at best. There is absolutely no way a true enterprise data warehouse could be represented in a star schema, or snowflake either.
I want to create a database that will server for reporting services and maybe (if that isn't enough) install analisys services and extract reports and data from cubes.
My question was : Is it really necesarry to redesign my current database and follow the star/snowflake schemas with fact and dimension tables ?
Thank you
© Server Fault or respective owner