SIL_PositionDimensionHierarchyFrom the log file i got the error like "ORA-26002: Table BIAPPS.W_POSITION_DH has index defined upon it." While googled related to that error i found to follow the below solution like
Where i need to do the above changes can you explain the above points elaborately inorder to do the changes for the failed task to resolve.
Change the Target Load Type to be Normal. Drop the indexes before loading the target.Disable the Enable Parallel Mode option.
Drop the indexes before loading the target.whether i need to drop all the indexes that was created in the table "W_POSITION_DH" in DWH, i have more than 50 indexes created for that table
Disable the Enable Parallel Mode option.Also for the above point where i need to enable the parallel Mode option in DAC.
ORA-00001: unique constraint (BIAPPS.W_POSITION_DH_P1) violatedAs the above index is related to the ROW_ID column of my table W_POSITION_DH which has nearly 14,432 records.