We are getting the following error while running the interface in ODI:
ODI-1228: Task int_jda_loc (Integration) fails on the target ORACLE connection ORCL_JDADVDB.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression.
Please suggest your thoughts and suggestion on the same.. how to resolve the above issue... as it is not telling which column datatype is not matched !!!
SELECT list item from source table to a SELECT list item from target table may have different datatype
Check that all corresponding SELECT list items have the same datatypes (and same size) from both source and target tables.