All Discussions Tagged 'ETL' - OracleConnections2024-03-28T11:18:16Zhttp://www.oracleconnections.com/forum/topic/listForTag?groupUrl=oracle-business-intelligence-applicatons-obia&tag=ETL&feed=yes&xn_auth=noHow to Eliminate Unique Index Errortag:www.oracleconnections.com,2013-09-27:6612035:Topic:385002013-09-27T07:16:32.095ZNaeem Akhtarhttp://www.oracleconnections.com/profile/NaeemAkhtar
<p>Hi,</p>
<p></p>
<p>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.</p>
<p>For example if we are encountering error on duplicate records on W_EMPLOYEE_DS table.</p>
<p>Query to Find duplicate records will be as below. </p>
<p></p>
<p>select integration_id, datasource_num_id, src_eff_from_dt, count(*)<br></br>from w_employee_ds<br></br>group by integration_id,…</p>
<p>Hi,</p>
<p></p>
<p>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.</p>
<p>For example if we are encountering error on duplicate records on W_EMPLOYEE_DS table.</p>
<p>Query to Find duplicate records will be as below. </p>
<p></p>
<p>select integration_id, datasource_num_id, src_eff_from_dt, count(*)<br/>from w_employee_ds<br/>group by integration_id, datasource_num_id, src_eff_from_dt<br/>having count(*)>1;</p>
<p>and query to delete duplicate records is as below.</p>
<p>DELETE FROM w_employee_ds<br/>WHERE rowid not in<br/>(SELECT MIN(rowid)<br/>FROM w_employee_ds<br/>GROUP BY integration_id, datasource_num_id, src_eff_from_dt);</p>
<p></p>
<p>Regards</p>
<p>Naeem Akhtar</p>
<p></p>