How to delete duplicate data from w_opty_d

Question

Hello Experts,

I have a query related to w_opty_d.

In the source s_opty, there was some duplicate record has been created, and it was loaded into the w_opty_d.

yesterday from the source s_opty client has deleted those duplicate records.

now they are telling to delete it from w_opty_d. For all the loads we are using DAC.

Can you please guide what is the best way to delete those records from warehouse table w_opty_d.

Regards

Thomas Dodds · Answer

since it's a dimension makes sure you know which rows by the unique constraint on the table you are to delete ... and BEFORE you delete the duplicates, make sure you have repointed ALL fact rows connected with the WIDs to be deleted with the same dimension WID that will remain.

BACK up the table as-is BEFORE any deletes ...