How delta works for write optimized DSO?

364 Views

Dear experts,

I have a data flow which is from a standard DSO A to a write optimized DSO B, and I set write optimized DSO B's DTP as delta.

1. During the delta loading, DSO B will read from A's change log table, correct?

2. Because write optimized DSO only has one active table, and each entry is unique, if I keep feeding this DSO B to other DSO's, let's say DSO C, how can DSO C determine which entry is the most recent one?

For example, in DSO B I have below 2 entries with same semantic key but different tecnical key:

REQUEST DATAPAKID RECORD ORDER NUMBER

DTPR_1 0001 1 001

DTPR_2 0001 1 001

While loading from DSO B to DSO C, will DSO C read both entries or only the entry in the most recent request?

If I write a abap program to read DSO B's active table, what will happen? both entries will be fetched or only the most recent one?

3. If I set a filter in DSO B's delta DTP, this filter will act on the change log during the loading, correct?

For example, if I set filter: ORDER NUMBER = 001 in the delta DTP, then during the delta loading DSO B will only read DSO A's change log table whose ORDER NUMBER = 001. Correct?

Those are all the questions I come up so far, any post will be appreciated, and thank you all for your time in advance!

Best regards,

Tim