Master data DSO

[saravanan_a]

Hi Experts,

My flow is Master data (ECC) --> DSO (BW)

I checked the delta process type is AIE.

How shall I handle if any record gets deleted from ECC Table ?

Adding & Editing a record is working fine ECC to BW.

I am planning to do delete entire content of DSO and do Full load from ECC to BW. Is there any other solution?

Please suggest.

Thanks,

Saravanan.

[FCI]

If no deletion indicator is available in the source, a complete deletion followed by a full load will be the easiest solution on the BW side..

There is ways to make the deletion optional but the full load is mandatory and it is the costly part.

So, I guess there is no better solution.

Regards,

Frederic

[sdsunny372]

Hi saravanan.a,

1) Check deletion indicator/flag for ECC table ,which you are using and based on that apply logic or filer at BW side.

2)If no deletion indicator is there, do full load at info package and full load for dtp,but do not forget to delete PSA data and DSO content older thn 1 day to avoid duplication or double records.

Best regards,

Sagarkumar Darji