ODI Error - ORA-01790 expression must have same datatype as corresponding expression

ORA-01790 expression must have same datatype as corresponding expression

If you are trying to connect two different values that can not be implicitly converted (in a mapping, a join...). Use the explicit conversion functions on these values.