Is it possible to simulate a delta load on BW side?

[Former Member]

Hello experts,

This is our situation: we have 2 ODS's A & B connected. B is the data target of ODS A and is loaded by delta loads.

I did the first init load successfully and now I want to run a delta load to check how data will look. There is a problem though, queue delta has been deleted in R3 and the PSA for ODS A as well. Is there a way to "manipulate" data in ODS A so when I run a delta, ODS B picks up the records I have modified?

[ram_pandey · Accepted solution]

If B is the data target of ODS A, and is not getting data directly from R/3, you wouldn't need to make any changes. The delta for B won't be affected as it gets its data from the change log of ODS A. It will only pick up the records changed since the previous load.

[Former Member]

Hi,

If your ODS A is the data mart layer. Then there your BW delta from ODS A to B is not going to affected.

Please set your delta for ODS a via delta init without data transfer as same selection as earlier and it will bring up the whole loads from R/3.

Also this will not affect your BW internal Delta to ODS B.

Regards,

Mahesh