Is there a way to merge a temp partition to the cube faster? -
08-26-2003
, 02:44 PM
Hi:
I'm process a cube by Incremental Update (using DSO), in which a temp
partition is created, processed and then merged with cube's default
partition. I found out that the time taken to merge is quite long. Any one
knows how to speed up the merge? For example, is it possible to process the
temp partition in RAM and then merge with the cube's default partition? Or
pre-allocate enough disk space for the cube's default parttition so that
there will be no phyisical space merge later when a temp partition is merged
with it's cube? Just my guess, do not know if OLAP provide such flexibility.
Thanks for your info |