Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00001: unique constraint and MAPPING

mmoayedSep 13 2019 — edited Oct 14 2019

Hallo everyone,
I did Mapping to a table have 6 fileds as Primary Key. The problem is that ODI Mapping is genearting Error ORA-00001 whereas SQL generated BY ODI when I run it in SQL developer .There is no problem data inserted without error,and I tracked the data and there is no duplicated records. I have filed wich is TIMESTAP and I am using this funtion to convert Date to TIMESTAMP

to_timestamp(TABLEVIEW.E_DATE,'YYYY-MM-DD HH24:MI:SS')

Can anyone help ?

BR,

Added on Sep 13 2019

#business-intelligence-applications, #data-integrator, #system-management-and-integration

20 comments

1,166 views