Question:
hello,
we are on 3.0b.. i have 4 update rules to a cube... they are mostly full loads.. is there a problem if we don't sequence the loads into the cube..
i mean can i start all loads at 7am into the cube.. since they are coming from different sources.. it should not be a problem, right?
i realize i can build an ODS to collect the data from diffrent sources and do one load to a cube.. i am wondering if i can cut one step out of this process.
Answer:
We have a similar process of building a cube everynight from 4 sets of data but we have it scheduled sequentially in a process chain insteed of all at the same time .
You could give it a shot but I wonder you may get into locking issues with the fact table as all four loads are trying to update the same set of key figures. Also parallel processing need not be the fastest always especially if you have limited horse power on your m/c.
Better be safe and do a sequential load.
ST