I am new to data warehousing and have a few initial questions -- sql server data warehouse

Russell
5/2/2005 1:55:01 PM

1. Just to clarify a datamart is collection of dimension tables that related
to a particular fact table within the data warehouse? I understand that the
same dimension table can be used more than once e.g. the Time dimension.

2. I would like to use Analysis Services with Reporting Services to create
the cubes etc. However some people are keen to use Cognos Impromptu with
Powerplay to implement the cubes etc. Are there any advantages that this

JT
5/5/2005 12:00:00 AM

I typically think of a datamart as being department specific (such as
Accounting or Payroll) and a data warehouse as being a consolidation of
multiple datamarts across the enterprise.

[quoted text, click to view]

sql server data warehouse : I am new to data warehousing and have a few initial questions