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