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
dbahooker@hotmail.com - 27 Feb 2006 21:38 GMT
a) you dont MOVE your data you process an OLAP cube out of a datamart
or database
b) it's hard work; i would start with www.databasejournal.com they have
100 articles about doing it in 2000; im sure they have some for 2005
already
c) get a couple of books
d) spend a week reading stuff before you worry about getting a demo up
e) once you're in olap land enjoy; it's a lot more fun than the
relational world