Generic Delta extraction problem
I have created a generic datasource on eban table and field for generic delta is ERDAT (Last changed on date). and it is time stamp with upper limit as 1800 seconds.
I took init and then changed one Purchase Requisition. then i took delta and that changed one came to BW. now if i execute the delta infopackage the changed record is still coming. ideally, once it has been transferred to BW, next delta infopackage execution should return 0 records. but it does give the same 1 record.
Please guide further.
M. Verbaan replied
As proposed above indeed use 1 day, but I would use it for the lower limit and use ERDAT (has data element AEDAT = change date: make sure if it is filled when document is created and changed!).
This way you will never miss any data (prerequisite: data is loaded every day!).
The lower limit of 1 day will cause double records to be loaded but this doesn't matter if you first load to DSO. Most recent data will overwrite the older data (when recs have similar key). Better to be safe than sorry