I am facing issue when Informatica coverts Integer value to Double and this double value isnot inserting into Number datatype column in Terdata.
Informatica Converts to :20109524.00000000
Terata DataColumn type : Number.
Is it just one value? How about this setting: "Enable high precision property in Session level"
Teradata data column type : Is it just number or number(m,n) in target?
Did you try this option?
Source (Integer) --> Informatica source (Read as string) --> cast String to number in Mapping
Yes, if infa works it that way and you can't change then need a work around. If you can't change the target data type, then maybe you need an extra step.
I remember one occassion with SAP DS. My source is geo-spatial data type. It could not load to Teradata geo-spatial data type. So what I did was , I loaded into a temporary table as string only for that field, the rest remained as-is. Then post-etl, I loaded into target table.
So, you can try what you feel is better.
Should have gone to Informatica forum ..... as its more of an Informatica issue.
Also, if the data-type is INTEGER at source and target, why Informatica is converting it to DOUBLE? It should keep it as INTEGER.