I am loading data from flat-file to oracle table.
In flat-file I have a field, which holds the value like "871685900000027865" and its datatype in SourceQualifier is Decimal.
But in oracle target it is loading as
"8.71685900000003E17"
While running Debugger, I found out that, In the Source Qualifier itself data is changed to exponential form.
Please suggest an easy approach to load data as it is into target.
Use "Enable High Precision" session property.
I'd also add that in the Flat File it's a string. Flat files do not have any datatype definititions - these are just flat text files. So once you've specified Decimal in Source Qualifier, it tries to do the conversion for you. And with High Precision not enabled, it will use the exponential form. This is by design.
But again: what you get from DB strictly depends on the table definition and client tool that you're using. Can you share or check the table definition? If the column is decimal, it should not store data in this form.
