Wednesday, March 28, 2012

How to create or learn AdventureWorks Data Warehouse

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:

> 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
|||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@.gmail.com> wrote in message
news:1160391925.433024.115200@.i3g2000cwc.googlegro ups.com...
> frankie lo wrote:
> 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
>
sql

No comments:

Post a Comment