All Forums Database
kishlay_TD 14 posts Joined 04/14
03 Apr 2014
Number Datatype issue with Teradata

Hi,
I am facing issue when Informatica coverts Integer value to Double and this double value isnot  inserting into Number datatype column in Terdata.
Source Data:20109524
Informatica Converts to :20109524.00000000
Terata DataColumn type : Number.

Raja_KT 1246 posts Joined 07/09
03 Apr 2014

 
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
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

kishlay_TD 14 posts Joined 04/14
03 Apr 2014

Hi Raja,
Its just number in Teradata.
 

Raja_KT 1246 posts Joined 07/09
03 Apr 2014

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.
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Adeel Chaudhry 773 posts Joined 04/08
08 Apr 2014

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.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.