Dear All ,
We have a situation where Data is moving from DSo to Cube and the volume of data was 30 millions records.
So to improve this we have divided our load into three categories based on Archived and Non Archived VErsion.
Archived Version getting loaded Weekly /Monthly
Non Archived getting loaded on Daily Basis.
Now Weekly load is to happen only on Sunday and monthly on 2nd of Every Month.
Weekly load still will take more than 6-7 hrs. where as Monthly load will take 8-9 hrs.
What if any month 2nd of Month is a Sunday .like 2nd Dec 2012.
We need to load Daily , Weekly , Monthly all the three loads into same cube with different process chains.
Could you please help us in understanding how we should achieve this by noy making much dependency on each of the processs chain.