issue with Decimal(38,0)

Database
Enthusiast

issue with Decimal(38,0)

im trying to insert data from data files through informatica to teradata target tables

one of the column is decimal(38,0) and input in the file for this field as 2071037681403375494292207177547 (31 digit number)

while inserting into table it is inserted as 2861015799783000000000000000000 ,where as i need the full number need to insert .

any one please suggest me it is urgent .
4 REPLIES
Enthusiast

Re: issue with Decimal(38,0)

any one please help me
Enthusiast

Re: issue with Decimal(38,0)

I think you need to enable large decimal support in the ETL tool. I'm not familiar with Informatica but I've seen that type of setting in TPT and OleLoad.
Enthusiast

Re: issue with Decimal(38,0)

i tried to set the property enable high precision value ,but still the same issue
Teradata Employee

Re: issue with Decimal(38,0)

Hi Sunny,

Are you still facing the problem with decimal(38,0)?

Please provide the OleLoad/Utility versions to recreate.

Thanks!!!