UDM and Star Schema

Hi everyone,

I have a general question to datawarehousing and it'll be great if someone can drop some tips here. I'm about to start designing a corporate real time datawarehouse with SQL Server 2005 and is deciding on the approach for this.

SQL Server 2005 now allows us to actually build a datawarehouse without actually restructuring the datasources into star/snowflake schemas. I'm curious to know if this will have any performance impact on the actual implementation? This project will probably require the usage of proactive caching as well as medium latency molap storage structure.

By using proactive caching, SSAS will intelligently switch between ROLAP and MOLAP depending on the data changes in the production database. What is confusing to me is, what happens to ETL then? Does this mean that if SSAS is made to query directly from the production database, then ETL is totally eliminated?

Any recommendations will be appreciated.

Thanks.
Nes
.

Loading