Datawarehouse Architecture

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron Relph (x_at_x.com)
Date: 02/23/04


Date: Mon, 23 Feb 2004 12:01:42 -0000

Hi,

I am trying to come to terms with some of the concepts of datawarehouse
architecture design. Utilising Microsoft tools, is it feasible that I build
cubes for each subject area and let users report off the cubes with Excel
and Reporting services, or should I also expose the data held in the staging
tables themselves? My cubes are sales and claims oriented in the Insurance
industry.

Thanks