Hi Friends,
We have been loading data to a DSO (Standard) and then to the cube.
data load to the DSO is a delta from another DSO (Write Optimised). The issue I have is i have loaded multiple requestes to the Standard DSO and then to the cube. Now there is an issue with data for one of the request, so I have to deleted the request from the cube so data is removed for that request.And now I have to selectively delete data from the DSO because other data loads happened after the request which has an issue. Hence If i have to delete the request which has this problem, then I have to delete all the other requests which were loaded after this one and also from the cube.
So I have deleted the data from DSO selectively from Active table, however Change log entries still remain. Without deleting Change log if I reload the corrected data, I will get the wrong results. So I tried the option in the DSO administration Delete Change Log, but here I can delete change log either by number of requests or older than a specific date. This means if i choose either one of the options then there will be an issue if a delta comes thru for data which was loaded with other request. My question is is there a way I can delete Change log data for a specific selection?.
I have gone thru different threads but i found only how to delete by older than a specific date.
Your help is appreciated. Thanks you in Advance.
Regards
Naveen