Does FACT table get Locked?

  • My cube takes over 6 hours to be processed. During this time is the FACT table locked by SQL or can I perform INSERT's into the FACT table??

    I guess 'UPDATE' and 'DELETE' will not be possible or will it?

    Would appreciate any help on this,

    thank you

  • You should consider building partitions for your cube based on the Time Dimension.  In this way you can process the entire cube once and then only process the latest partition (e.g., year, quarter).  This would be considerably faster.

    See Books Online under partitioning...cube storage for info on how to partition a cube.

     

    Pete

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply