Oracle Community Network
During the ETL process of BI Apps. we encounter error like "create index failed" frequently. This happen due to the duplicate data in DWH. We can delete duplicate data to rescue the ETL.
For example if we are encountering error on duplicate records on W_EMPLOYEE_DS table.
Query to Find duplicate records will be as below.
select integration_id, datasource_num_id, src_eff_from_dt, count(*)
group by integration_id, datasource_num_id, src_eff_from_dt
and query to delete duplicate records is as below.
DELETE FROM w_employee_ds
WHERE rowid not in
GROUP BY integration_id, datasource_num_id, src_eff_from_dt);