i am trying to update journalised data from one source to one target by using cdc a problem occured while exectuing
which displayed below please suggest me
"ODI-1217: Session journal_sample (125004) fails with return code 923.
ODI-1226: Step journal_sample fails after 1 attempt(s).
ODI-1240: Flow journal_sample fails while performing a Integration operation. This flow loads target table JOURNAL_SOURCE.
ODI-1228: Task journal_sample (Integration) fails on the target ORACLE connection odi.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected"
Check your SQL which generates on Load stage and at 'IKM' stage.
Seems some error in your mapping . You can copy those two sqls and verify it in your database where exactly the sql throwing the error.
This may help you to solve the problem.