SEO

#1 (**permalink**) 02-27-2008, 07:09 PM

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

#2 (**permalink**) 02-27-2008, 07:09 PM

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" <odeddror@cox.net> wrote in message
news:Od36QUkLIHA.5360@TK2MSFTNGP03.phx.gbl...
> 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
>
>

#3 (**permalink**) 02-27-2008, 07:10 PM

I would make a copy of the AdventrWorksDW, restore it, truncate the data,
open up ssis and start building a package. Also, read a book on ssis

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts

"Oded Dror" <odeddror@cox.net> wrote in message
news:Od36QUkLIHA.5360@TK2MSFTNGP03.phx.gbl...
> 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
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Moving from OLTP to OLAP sample