Building a Data Warehouse
- by Paul
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