Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

converting oltp database into dimension model (olap) database Expand / Collapse
Author
Message
Posted Wednesday, May 1, 2013 5:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 23, 2014 7:58 AM
Points: 115, Visits: 210
I work on ssas using adventureworksDW2008 database for creting cube and understanding other features but if I want to convert my oltp database such as Northwind database where data is in relational model(customers,products,orders tables)what exactly is the way I can do it.
Is there any mechanism that directly table will be converted to fact and dimension tables.
What I want is a way to convert OLTP Data into OLAp data for creating cubes.
I do not want to work on ready database like adventureworksDW2008.
Post #1448376
Posted Wednesday, May 1, 2013 9:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 1,163, Visits: 1,187
sej2008 (5/1/2013)
I work on ssas using adventureworksDW2008 database for creting cube and understanding other features but if I want to convert my oltp database such as Northwind database where data is in relational model(customers,products,orders tables)what exactly is the way I can do it.
Is there any mechanism that directly table will be converted to fact and dimension tables.
What I want is a way to convert OLTP Data into OLAP data for creating cubes.
I do not want to work on ready database like adventureworksDW2008.

It sounds like you're asking for a magic bullet that will convert a 3NF db to a dimensional model (star schema or snowflake off a star schema). I'm not aware of anything like this -- it boils down to having to do the data modeling yourself. A good book on star schema/modeling is the Kimball - 'Data Warehouse Toolkit' (the 3rd edition comes out in July). ( http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247/ref=sr_1_1?s=books&ie=UTF8&qid=1367416796&sr=1-1&keywords=data+warehouse+toolkit )

HTH,
Rob
Post #1448505
Posted Thursday, May 2, 2013 12:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 23, 2014 7:58 AM
Points: 115, Visits: 210
No I was not asking for any magic Bullet,I wanted to understand from scratch(the data itself)May be that was Data modelling which I was not aware.
Thanks
Post #1448699
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse