ROLAP date dimension link to OLTP datetime fields in tables
Posted on 2013-06-03
SQL Server 2008 R2
I have created a simple ROLAP database with four tables:
My DimDate dimension is already populated with date range and the rest of the tables are empty.
Now I want to transfer data from my OLTP database into my ROLAP database. My Date granularity is at the day level.
Now what I am absolutely stumped with is how do I load data from my OLTP database into my ROLAP database with regards to date?
So for example in my OLTP database if I want to load from 2005 -2007. How do I load this data into ROLAP database, so that the ROLAP database knows I'm loading data from 2005-2007 from the OLTP database. So if i run a query in the ROLAP for date range 2005-2007 I will get the same results as OLTP.
I have looked at AdventureWorksDW2008 and I cant figure out how data was loaded from OLTP into ROLAP whilst keeping the date in sync.
Ultimately what I am asking if I am loading data from any source into ROLAP, what actions do I take to match the data dates?