MS SQL Data Warehousing - Moving from OLTP to OLAP info?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Moving from OLTP to OLAP info?

Oded Dror

2006-02-13, 9:23 am

Hi there,

Where can I find information about
How to move your database from OLTP to OLAP
what are the steps (stage1 stage2 indexing issue etc..)
with real source code examples

In sql server we have Adventure Works OLTP database
And OLAP database but no one show you how to move
from OLTP to OLAP (like how they did that?)

The SSIS show you how to transfer data and BI show you how to work with your
data
(assuming you already know)
But there is no information about how to do this with source code

Thanks,
Oded Dror

Sponsored Links