Skip to Content
avatar image
Former Member

Loading data into and extracting data from the same cube

Hi Everyone,

Just a general question:

If I were to datamart from Cube A into Cube B, and data is being loaded into Cube A at the same time.

Would this scenario cause any conflict?

Cheers,

K.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 03, 2008 at 11:32 PM

    hi,

    if it were an ODS, I can say for sure that loading of A ll b success but activation ll fail, if A is loading another target at the same moment. (A kind of lock i can say)

    I suppose loading of cube A will get failed, if A is loading B.

    Regards,

    R.Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 06:41 AM

    Hi,

    Since we writing to one cube and reading the same cube simultaneously is should cause any locks as such because one database operation performed is a write and the other is a read. But the load from Cube A to Cube B might fail due to the fact that Cube A is still being written.

    Regards,

    Pramod

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I would recommend not to do both the loadings simultaneously. Most probably it will not allow to do so. The cube being loaded will be locked and you may not trigger any load from that cube as a source.

      Regards,

      Yogesh