This content has been marked as final. Show 5 replies
i am trying to populate target table using scd1 using KM is ikm oracle incremental update.i am trying to map sid with some seq which is can be used as native sequence in ODI but i am getting error is below
ODI-1217: Session INF_SCD1 (196001) fails with return code 936.
ODI-1226: Step INF_SCD1 fails after 1 attempt(s).
ODI-1240: Flow INF_SCD1 fails while performing a Integration operation. This flow loads target table DIM_EMP_SCD1.
ODI-1228: Task INF_SCD1 (Integration) fails on the target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
note: but successfully populated to target when not used sequence(surrogate key) in my target.