Delta Extractor key field failing ? for generic ds
My Generic Delta DS seems not to be working and run out of ideas why?
I have a delta based on the last modification date field of r/3 table (EBAN) from where my filtering logic establish that the extractor only loads data when delete indicator is no set .
Hence after an initial load I modify data at the source (r3) and put some deletion flags on.
Extractor in RSA3 has corresponding line(s) less omiting deleted documents id. But when I run a new delta update in BIW no data is modified and register is not delete it from infocube. (my DS loads thru ADD delta process directly into Icube)
Is my key field for Delta wrong? ( i runned it 2 same day) or is my filtering logic wrong?
Appreciate your help (the most the welcome)
Olivier Cora replied
because of the example below, you can't pump this datasource directly in an InfoCube: you'll have to stage it in an ODS first so that the ODS provides only the delta to the InfoCube; in this case the date shall be included in the data part of the ODS (not in the key). I believe that in your case the key of your ODS should be Doc# + Item#....
hope this helps...