Hi All,
I have a requirement where I am loading a CSV file to oracle table ..The load and everything works fine. total we have 5 fields in the table..below are the table fields.
Now what we have to do is
- update the hours only if other 4 fields are same in the database otherwise add data
- Primary key field should be updated using sequence..
The primary key filed is a not in these five fields. these five fields are coming from CSV file and in the target table we have more than these five fields.
for this what I did is I changed the IKM to IKM SQL Incremental update and unchecked the insert box on the hours field in the target.
When I do this and run the mapping it's failing with error at flag rows for update step.
ODI-1228: Task INF_RESOURCE_WB (Integration) fails on the target ORACLE connection
Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
this is the code
update tst.I$_t1
set IND_UPDATE ='U'
where exists(
select 'X'
from tst.I$\_t1 T
)
Any suggestions please