Selective deletes from ODS and Cube
I have an ODS, which has 4 key fields - Material, Plant, Date, Type.
During a delta update, I want to be able to go up to the ODS and Cube and delete all of the records for all Material/Plant combination that are found in the Delta load.
However the incoming delta does not have the full key combination of the records that need to be deleted. Another words it is not a one to one key match. As a result I can not simply move "D" to 0recordmode indicator!
I also want all the records for a the Material/Plant combination in the ODS and Cube to be deleted, before the received delta data is posted.
Is there a way to do it? Please let me know.
You are loading data into a standard ODS object. Correct.
When you load data, it goes into New table or activation queue. When you activate the data, it moves into active data and changes are then logged into Change Log table.
check this link for more on this
If your ODS is enabled for "Automatic actiation" disable it by right click-> change-> Settings-> remove the check mark for automatic activation.