Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to delete duplicate data from w_opty_d

Received Response
1
Views
1
Comments
user12116294
user12116294 Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications Forum

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

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    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 ...