I am facing an invalid number error while loading data from an ORACLE view to an Oracle Table. But, the query generated by ODI (when simulation is run) works perfectly when executed in the target database.
I tried changing all the source and target datatypes to String and VARCHAR2 but the error persists!