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.
Hope you have an Enterprise version and properly partitioned measure group for that fact table. Then you have basically two possibilities. 1. Process the cube as a whole (but this processing can be relatively long). 2. Process the cube per partition - process one partition at a time. 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.