Re: How to create or learn AdventureWorks Data Warehouse

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


frankie lo wrote:

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????
you can find a good start from here

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

Regards
Amish Shah

.

Relevant Pages

  • How to create or learn AdventureWorks Data Warehouse
    ... Would like to learn how to create Data Warehouse. ... source/book to show that how to generate it from "AdventureWorks OLTP". ... show the process from "AdventureWorks OLTP" database to "'AdventureWorks ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: How to create or learn AdventureWorks Data Warehouse
    ... "'Adventure Works Data Warehouse" was well-developed and then to start to ... source/book to show that how to generate it from "AdventureWorks OLTP". ... Data Warehouse " to "AdventureWorks AS or Cube", ...
    (microsoft.public.sqlserver.datawarehouse)