How to create or learn AdventureWorks Data Warehouse

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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????


.



Relevant Pages

  • 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)
  • Re: How to create or learn AdventureWorks Data Warehouse
    ... Warehouse" sample is great sample. ... source/book to show that how to generate it from "AdventureWorks OLTP". ... I know that there are many sources to show the process from 'AdventureWorks ...
    (microsoft.public.sqlserver.datawarehouse)