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 !!!
Check below URL for your reference if you are using any select query in ODI interface http://www.techonthenet.com/oracle/errors/ora01790.php
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.