I am trying to load data from flat file to oracle table.
The flat file has data as string and the value is 123412345678.123457689123 When converting to decimal , the value is becoming as 123412345678.123000000000
The target column is number (38,12). In the mapping I have defined the data type as decimal (38,12) while converting to decimal.
Any inputs?
Is the 'Enable High Precision' checked? Please read the following guide.
Briefly: without the high precision enabled, the data is converted to Double and precision loss occures. If high precision is enabled, this will work up to 28 digits. With larger values it will still happen.
The only way to make sure you have this always working right is to process this as string.