CODEWITHSUNDEEP
informatica
MOHAMMED SHEIK DAWOOD S J
MOHAMMED SHEIK DAWOOD S J

Reputation: 81

Informatica - Number Datatype issue

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.

enter image description here

But in oracle target it is loading as 

"8.71685900000003E17"

enter image description here

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.

Client Screenshot For reference

Upvotes: 0

Views: 2322

Answers (1)

Maciejg
Maciejg

Reputation: 3353

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.

Upvotes: 2

Related Questions