we have ODS which has multiple initialization based on selection .
Now if we want to delete all the request related to one o the selection initalization then can we do it in one go.
I want to delete the records from active data table and change log as well.
as already explained in the past, after your several init loads, delta is summarized in only one...so, after the inits, there isn't a delta belonging to an init and a delta belonging to another one: delta is unique.
So you can do only a selective deletion based on the criteria you want to use.
Hope it helps!
I think it is not possible to delete all the reqests related to one init at a time.
Deleting Data from the ODS Object: