1 Reply Latest reply: Nov 25, 2012 11:35 AM by JeromeFr RSS

    SCD TYPE 2 in ODI 11g-error in INSERT CHANGING AND NEW DIMENSIONS

    976061
      Hi Guys,

      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.


      Thanks,
      Sreedhar S,
      <telephone number removed by moderator. this is a publicly viewable forum, not Oracle technical support>