May 1, 2013 at 5:41 am
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.
May 1, 2013 at 9:48 am
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
May 2, 2013 at 12:10 am
:-)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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply