Load to ODS

[Former Member]

Hi,

I have a data source, which is SAP generate records. Every time user change the data, system will delete the old records and create a new one. If I load this data source to cube, I can use "delete overlap request" to delete last time load and reload it again. If I want to load it to ODS, I have no option to delete the overlap and the deleted records won't come to BW to change to ODS, how can I do the same thing like cube.

Thanks

Victor

[Former Member]

Victor,

If ODS have proper keys it will Overwrite the overlapdata.

If you want to delete data for diffrent purpose then you can write an ABAP program to delete the overlap data and put it in process chain sothat it will delete old records and load new data .

Ravi

[Former Member]

Thanks.

Becasue SAP always create new key and delete the old one, I have no way to keep track that one in ODS. And I alos want to load from ODS to Cube. If I delete ODS with ABAP, does that affect my loading to Cube?

Thanks.