Oracle Business Intelligence (BI) Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization from front line employees to senior management that enable better decisions, actions, and business processes. Designed for heterogeneous environments, these solutions enable organizations to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP.
Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive, innovative, and leading BI platform. This enables organizations to realize the value of a packaged BI Application, such as rapid deployment, lower TCO, and built-in best practices, while also being able to very easily extend those solutions to meet their specific needs, or build completely custom BI applications, all on one common BI architecture.
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(*) from w_employee_ds group by integration_id, datasource_num_id, src_eff_from_dt having count(*)>1;
and query to delete duplicate records is as below.
DELETE FROM w_employee_ds WHERE rowid not in (SELECT MIN(rowid) FROM w_employee_ds GROUP BY integration_id, datasource_num_id, src_eff_from_dt);
Oracle Business Intelligence Applications (OBIA)
143 members
Description
Oracle Business Intelligence (BI) Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization from front line employees to senior management that enable better decisions, actions, and business processes. Designed for heterogeneous environments, these solutions enable organizations to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP.
Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive, innovative, and leading BI platform. This enables organizations to realize the value of a packaged BI Application, such as rapid deployment, lower TCO, and built-in best practices, while also being able to very easily extend those solutions to meet their specific needs, or build completely custom BI applications, all on one common BI architecture.
How to Eliminate Unique Index Error
by Naeem Akhtar
Sep 27, 2013
Hi,
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(*)
from w_employee_ds
group by integration_id, datasource_num_id, src_eff_from_dt
having count(*)>1;
and query to delete duplicate records is as below.
DELETE FROM w_employee_ds
WHERE rowid not in
(SELECT MIN(rowid)
FROM w_employee_ds
GROUP BY integration_id, datasource_num_id, src_eff_from_dt);
Regards
Naeem Akhtar