Skip to Content
author's profile photo Former Member
Former Member

Direct vs Indirect data load from ODS -> InfoCube

We know that there are two options to load data from ODS to InfoCube:

1. Direct load:

If the ODS setting is checked with the option of "Update data targets from ODS object automatically", then when loading data to ODS, then the data also can be loaded to the InfoCube, in this way, only one InfoPackage is needed to load data to the ODS, then the InfoCube can be filled with data automatically.

2. Indirect load:

If the ODS setting is NOT checked with the option of "Update data targets from ODS object automatically", then not only the InfoPackage to load the data to the ODS is needed, but also the InfoPackage to load data from the exported datasource of the ODS to the InfoCube is needed to be created in order to load the data from ODS to the InfoCube.

I wonder what are the pro and con between the above two loading methods from ODS to InfoCube.

Welcome to every BW expert inputs!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2005 at 10:30 AM

    Hi Kevin,

    Using reconstuct of the request you can updtae the Data Targets in our case Infocubes. Comming to Update data targets automatically will update the data targets automatically.

    all the best.

    Nagesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2005 at 05:14 PM

    hi Kevin,

    actualy 'direct load' there is still infopackage from ODS to infocube generated by system, when we manualy click 'update data target' from ODS, we can see the infopackage.

    my 2 cents, pro reduce maintenance, done by system. con, perhaps if more than one requests are updated to ODS and the update from ODS-cube still running, when the 2nd request try to update infocube then will generate error, something requests lock, but can be avoid with well managed scheduling (process chain).

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Kevin,

      Direct Loads or rather Automated Loads are usually used where u need to load data automatically into the final data target. And it has no dependencies.This process has less of maintenance involved and u need to execute a single infopackage to send data to the final data target.

      But Indirect Loads are usually used when u have a number of dependencies and this ODs object is one of the object in a process chain. So if u require the this ODS data load wait till some other event has been executed , then indirect loads are used through process chains.

      Regards,

      JAsprit

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2005 at 03:11 PM

    Hi,

    This option (along with many other adm tasks on data targets) is from a version in which the process chain feature was not available. In my opinion these features should not be used as staging managent in newer versions are meant to be handled in process chains. In other words, it is a leftover from a time passed away and I think in version 7.x these features are no longer supported.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.