cancel
Showing results for 
Search instead for 
Did you mean: 

Generic Datasource with Additive Delta

Former Member
0 Kudos

Hi all

I have a question.

In whic case can I use a generic datasource with additive delta?

Does this delta mode make sens only with function module extraction?

If I extract data directly from a table, can I use this delta mode only if a field represents changes?

Thanks for your help!

S.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Stefania,

Additive delta can be used when you can introduce a field that map the "correction" of a previous upload.

If yesterday for Customer A you have uploaded a quantity 100 and today you want to upload 80 for the same condition you have to delete/reverse the previous upload and then write only A and 80, you can do this with a field like 0STORNO or 0RECORDMODE.

If you have not this filed it is better to use overwrite and upload first in an ODS.

Ciao.

Riccardo.

Former Member
0 Kudos

Thanks Riccardo!

Now I'm sure that my undestanding was correct!

Ciao!

Stefania

Former Member
0 Kudos

Stefania,

To my knowledge what you are thinking is wrong.

we have 2 Methods for Generic DS.

1. New status for changed Records.

2. Additive delta.

New status for changed records means

New Order

order no quantity

1000 10

order changed to quntity 8. then 2 records will posted 2 BW in first case.

1000 -10

1000 8

if you come to Additve delta.

for the same case it will send the same record as

1000 10

changed records

1000 -2

this is the difference. New status with changed records should be used only in association with ODS not cube becoz we don't have overwrite option.

Additive delta we can use for ODS and Cubes with update mode Addition.

Hope this is clear.

Regards,

Nagesh Ganisetti.