When using ODI to migrate data from a table in Oracle to another table in Oracle, the step described above fails because a line of code is missing from the where statement. See the error message and the example below.
Flow =
IKM Selector: Oracle Slowly Changing Dimension
Error Message:
ODI-1228: Task Ref_Pgm_TypeB (Integration) fails on the target ORACLE connection NGDEVACQPGM.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator
Code:
update ACQPGM.I$_REF_PGM_TYPEB S
set S.IND_UPDATE = 'U'
where (S.PGM_TYPE_CD)
in (
select T.PGM_TYPE_CD
from ACQPGM.REF_PGM_TYPEB T
where
and T.AUDIT_END_DATE = to_date ('01-01-2400', 'mm-dd-yyyy')
)