Skip to Content
0
Former Member
Sep 30, 2005 at 10:24 AM

Loading delta data to more objects

33 Views

Hello BW experts,

Does anyone have experience in loading delta information to more data target?

My situation is the following:

I’m running delta on sales-orders-header + sales-order-item. When I load the delta information directly to my cube everything works fine (No duplicated data is loaded)

At the moment I only have one cube, but it will be more in the future.

Now I want to introduce an ODS layer to be able to prepare my BW for future changes in reporting requirements. I will keep all original data from the datasource in the ODS and apply update rules/transformation only to the cube(s).

I then have 2 options, but which one should I use:

1) Load data (from the delta queue) to the ODS and to the cube(s) in parallel (same infopackage)

2) Load data (from the delta queue) to the ODS first, and then from the ODS to the different cubes

If option 2 is recommended how do I identify the new records in the ODS (just arrived from the delta queue) to be loaded to the cube(s) so I don't get duplicated data in the cube(s)?

Any suggestions are appreciated.

Kind regards, Torben