I have an oracle table feeding a fact table in ssas. 3 days of data is over 18,000,000 records and i have over 2 years of data to load. 2 Years of Date is about 450 Million records
I am in the development stages and I am wondering how to do my initial load to the cube
Any help would be appreciated.
asked Mar 22, 2012 at 04:10 PM in Default
Hope you have an Enterprise version and properly partitioned measure group for that fact table.
Then you have basically two possibilities.
In general it depends what load you can make on the source system and how you would like to have the cube available. Using the per partition processing and starting with the latest one and going toward older one you can make the latest data available earlier and make all the data available in stages.
answered Mar 22, 2012 at 07:49 PM