Question:
Hi,
I have build a generic extractor which retrieves data from sales orders and deliveries and sends it to an ODS object in BW (key: sales order, order item, material, requested delivery date, delivery number, delivery item).
During the past few weeks the "concept" changed quite a bit and since I didn't feel like starting all over (too lazy for that... and not enough time either) I tried "fitting" it in the same setup.
Now I have a "little" problem... I need to delete certain records from my ODS depending on the upload (I can check this via start routine and update rules - no problem there). 0RECORDMODE seems to be the field to use to have the entries removed from my ODS.
Here's the question: if I send the same record to my ODS with 0RECORDMODE set to 'D' (so the record gets deleted from the ODS), will it be removed from the InfoCube as well (with the next "delta" load) or not?
I actually can't test it on our development system right now, as it is being upgraded at the moment.
cheers,
El Belgio
Answer:
The previous record will still be in the cube. It will not be "visible" in the cube only if a record with 0STORNO = 'X' or 'D' gets inot the InfoCube.
I haven't really checked in the ODS if a record with 0RECORDMODE ='D' actually deletes the record or not. I should think it does.
_________________
Keep smiling
Answer:
That's what I think too... but I'd rather be sure, before I make the change
Answer:
0recordmode 'D' does delete from the ODS, but makes entries to the change-log. If you are doing this on a regular basis with lots of records, this blows up up your change-log (cf a previous reply of mine concerning 0recordmode).
Answer:
0recordmode 'D' does delete from the ODS, but makes entries to the change-log. If you are doing this on a regular basis with lots of records, this blows up up your change-log (cf a previous reply of mine concerning 0recordmode).
But if the change log is read to activate the ODS data, what happens to the records with 'D'?
_________________
Keep smiling