Skip to Content
0
Former Member
Nov 27, 2005 at 05:12 AM

Direct vs Indirect data load from ODS -> InfoCube

38 Views

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!