Skip to Content
0
Former Member
Jul 21, 2011 at 08:09 AM

Deletion of Duplicate records from DSO.

50 Views

Hi All,

I have a Write Optimized DSO with duplicate data, the data is duplicate at PSA level ,hence the Infocubes that have DSO as data mart also have duplcates for a day at the start of the month.

I have segregated the duplicates in an excel files and found the condition of selective deletion to the DTP request ID and data package and as we are working on a retail project , the store number that has the duplicate records.

Now for selective deletion, we dont get DTP request & Data package ID as conditions to delete teh record.

What are the possible methods that we can go for in this case?

and I need to delete all the requests in the infocubes after the date we have duplicate data and reload all the data from DSO into infocube.