DAC Run: Unique Index Creation Failing for the HR module
Hello,
We are runnign the BIApps (7.9.5) data load for “Human Resources - Oracle R12”
The following taks are failing during creation of unique index as there are duplicate integration id’s.
How should we go about handeling it. How do we determine which record with duplicate integration_id to delete?
1. TASK_GROUP_Extract_EmployeeEventFact
-------------------------------------------------------
CREATE UNIQUE INDEX
W_EMP_EVENT_FS_U1
ON
W_EMPLOYEE_EVENT_FS
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
);
2. TASK_GROUP_Extract_EmployeeDailySnapshotFact_Performance_Review
----------------------------------------------------------------------------------------------------------
CREATE UNIQUE INDEX
W_EMP_DSNF1_TMP_U1
ON
W_EMP_DAILY_SNP_F_1_TMP
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
)
3. SIL_InternalOrganizationDimension
---------------------------------------------------
CREATE UNIQUE INDEX
W_INT_ORG_D_U1
ON
W_INT_ORG_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT ASC
);
4. SDE_ORA_JobDimension
----------------------------------------
CREATE UNIQUE INDEX
W_JOB_DS_U1
ON
W_JOB_DS
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,SRC_EFF_FROM_DT Asc
);
5. SDE_ORA_PayGradeDimension
----------------------------------------------------
CREATE UNIQUE INDEX
W_PAY_GRADE_DS_U1
ON
W_PAY_GRADE_DS
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
,SRC_EFF_FROM_DT ASC
);
6. SDE_ORA_EmploymentDimension
---------------------------------------------------
CREATE UNIQUE INDEX
W_EMPLOYMENT_DS_U1
ON
W_EMPLOYMENT_DS
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
);
7. TASK_GROUP_Extract_EmployeeDimension
---------------------------------------------------------------
CREATE UNIQUE INDEX
W_EMPLOYEE_DS_U1
ON
W_EMPLOYEE_DS
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
,SRC_EFF_FROM_DT ASC
);