Moving from OLTP to OLAP sample

Hi there,

Where do I find some example like

How to move (ETL) the AnventureWorks OLTP database into AdventureWorksDW

All the examples start with the exsisting DW and I would like to know how to
do it myself?

where can I find some sample (scripts) how to move your database in to Data
Wharehouse?

This process seems falling between SSIS and SSAS but no sample of how to do
it

Thanks,
Oded Dror

You need to buy Ralph Kimball book to step you through the process. Using
his book as a guide, you will learn how to gather the requirements that
should be driven by the business area NOT technology driven. He has
templates and guides to help you through the process. Start with a small
subject area and build a data mart first. After you get the data mart
complete, use SSAS to create a cube.


"Oded Dror" wrote in message

> Hi there,
>
> Where do I find some example like
>
> How to move (ETL) the AnventureWorks OLTP database into AdventureWorksDW
>
> All the examples start with the exsisting DW and I would like to know how
> to do it myself?
>
> where can I find some sample (scripts) how to move your database in to
> Data Wharehouse?
>
> This process seems falling between SSIS and SSAS but no sample of how to
> do it
>
> Thanks,
> Oded Dror
>
>