We have one full load to cube happens from an InfoObject . Before loading into cube we
1.delete the indexes of cube
2. delete complete cube data along with delting of dimensions
the problem is that it takes 12hrs to load data and it is taking time only at SID generation step nearly 7 to 8 minutes. Total cube size is nearly 4 million. There are no routines, no transformation logic etc..
please provide me solution to increase data load performance to cube.
How far it is a good idea to do number range buffering for dimensions?
i have done the following checks
1.none of the dimension size is not more than 10% of cube size
2.we have increased the dtp job to 6