Suppose that there is web site with millions of transactions. Its manager needs to see semi real time multidimensional reports. How is it better to perform the ETL process? What kind of architecture we should use to Extracting data from databases, Transforming and then loading them to the data warehouse? Is it a good solution to perform the ETL process every hour or every half hour? What kind of risks of performance we may face? Do we always need to have a data warehouse to get rich reports? Thanks

Hmm, if he\she wants to see reports in real time I think you would be better of to create SSRS report that based on SELECT statements needed for report.. To seep up the query you need properly defined indexes. SSRS has caching to run reports from the memory... Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/