Number Datatype issue with Teradata

Database

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.

4 REPLIES

Re: Number Datatype issue with Teradata

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

Re: Number Datatype issue with Teradata

Hi Raja,

Its just number in Teradata.

Re: Number Datatype issue with Teradata

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,

Teradata Employee

Re: Number Datatype issue with Teradata

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.