Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / February 2006

Tip: Looking for answers? Try searching our database.

Moving from OLTP to OLAP info?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Oded Dror - 13 Feb 2006 14:15 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.