I did a simple tOracleInput to tOracleOutput. I got error
tOracleOutput_1 ORA-01727: numeric precision specifier is out of range (1 to 38).
My input source has only 28 and the output schema was sync.
I checked online that ORA-01727 can be resolved by sspecifying a NUMERIC datatype which is a precision value between 1 and 38.
I should not need to do this since the source and target Oracle database is the same.
Any suggestions? Thank you very much.