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(*)fr…
You can share this discussion in two ways…
Share this link:
Send it with your computer's email program: Email this