| Author |
How to create or learn AdventureWorks Data Warehouse
|
|
| frankie lo 2006-10-25, 6:00 am |
| 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
| |
| frankie lo 2006-10-25, 6:00 am |
| 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.googlegroups.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
>
|
|
|
|