Would like to learn how to create Data Warehouse. "AdventureWorks Data
Warehouse" sample is great sample. but it seems like that there is no
source/book to show that how to generate it from "AdventureWorks OLTP".

I would like to want to know the "PROCESS" or 'WHY ->>>> design these fact
or dim tables" and "Business Logic" behind.

I know that there are many sources to show the process from 'AdventureWorks
Data Warehouse " to "AdventureWorks AS or Cube", BUT there is few source to
show the process from "AdventureWorks OLTP" database to "'AdventureWorks
Data Warehouse".

Any advices????

frankie lo wrote:


ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/db55e226-601a-4026-8651-573195555a59.htm

Regards
Amish Shah

Hi amish,

It is 'SQL Server 2005 Analysis Services Tutorial", it assumes that
"'Adventure Works Data Warehouse" was well-developed and then to start to
create cube by AS.

What I am looking for is how to create fact/dim tables in ''Adventure Works
Data Warehouse".



"amish" <shahamishm (AT) gmail (DOT) com> wrote