cancel
Showing results for 
Search instead for 
Did you mean: 

Loading data into and extracting data from the same cube

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

yogesh8984
Contributor
0 Kudos

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

former_member619464
Active Contributor
0 Kudos

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