Skip to Content

Parallel Loading of Cube

Hi All,

Before we have one ODS for all company codes and one cube for reporting.

Due to some performance problems we created the regional ODS for each company code by keeping the same consolidated cube at top.

Is there any possibility of table locks at Consolidated Cube if its populates from all regional ODS at a single time , if so how can i keep them in sequence.

The Regional ODS were designed with automatic update option and we have one upload per day.

Could you please kindly some experts have some valuable inputs on this design.

Thanks & Regards

Martin Leo

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 20, 2004 at 01:08 PM

    I dont think simultaneous loads from all ODSs is going to lock up the fact table.

    However I do suggest that having them load sequentially is a better option because when you load it a same time, you will trigger of a lot of background processes which can time each other out.

    Why dont you put these ODS loads in a sequence in a process chain to execute one after another??

    Lets hear some other opinions from experts

    SR

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 20, 2004 at 09:31 PM

    Hi SR,

    Thanks for valuable inputs.

    We are using one info package to pull the data from R3 and distributing the data into several Regional ODS in start routine.

    As per my assumption there is no Fact Table lock ( Les number of records ODS activate first and updates the cube)

    But if there is 5 percent scope for table lock , we are in big trouble where our reports were palced in Portals.

    Kind Regards

    Martin Mouli

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Martin,

      I have never heard of fact table locks. There is the Master data table being locked but never experienced or heard a fact table being locked. So you should be fine. and as you said less number of records ODS will go first.

      Try this once and if it doesnt work, I will think about a suitable process chain for you.

      SR

  • avatar image
    Former Member
    Aug 24, 2004 at 03:54 PM

    There should be no locking issues in laoding multiple infopackages into one infocube. IF you are using Oracle, be aware that a new partition is generated for each InfoPackage load, and that the only way to manage the number of partitions is through InfoCube compression.

    If you have been able to segment your ODS by company code, perhaps you should consider making the "Consolidated Cube" a MultiProvider, consisting of seperate base cubes that each hold one company code's data. That way you have a global view with good performance advantages (parallel processing, sub-queries read smaller tables, etc).

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 24, 2004 at 05:38 PM

    Hi Ron , SR,

    Thanks very much for experienced inputs.

    This Consolidated cube already having the data Since Jan 2004 to July 2004 and we created Regional ODS to update this cube from August to December 2004.

    It could be possible for Regional Cubes to feed the data from related Regioanl ODS in next year.

    Thanks on the same.

    Kind Regards

    Martin Mouli

    Add comment
    10|10000 characters needed characters exceeded