Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
System Management and Integration
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 25, 2012 11:35 AM by
SCD TYPE 2 in ODI 11g-error in INSERT CHANGING AND NEW DIMENSIONS
Nov 25, 2012 11:04 AM
Im using IKM:Oracle Slowly Changing Dimension to achieve SCD TYPE 2.
It is working fine for Overwrite on change.
But whenever there a new insert upon change(Add Row on Change) in source, throwing below error:
ODI-1228: Task INT_EMP_SCD_TYPE (Integration) fails on the target ORACLE connection ORA_DEV_EDW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_EDW.EMP_KEY) violated.
I have unique key in target table column SAPID.
How to overcome this issue.
quick help would be highly appreciated.
<telephone number removed by moderator. this is a publicly viewable forum, not Oracle technical support>
This content has been marked as final.
Show 1 reply
Re: SCD TYPE 2 in ODI 11g-error in INSERT CHANGING AND NEW DIMENSIONS
Nov 25, 2012 11:35 AM
in response to
As said in the error message, you have an unique or primary key on one column and you try to insert a value already existing. This is a design issue.
You have to ensure that you don't try to re-insert existing value for the column(s) with the key.