Decimal_From_Decimal Warning Issue

senthilt1 · Post by **senthilt1** » Wed Jul 15, 2015 4:43 pm

Hi All,

I am extracting the data from Oracle and loading into Teradata Database. In oracle I have the datatype as decimal(38,10) but in Teradata it is decimal(9,4) only as confirmed by DBA and they recommend to Round off the decimal points in TD.

I am using the DecimalfromDecimal with round_inf option, But I am getting the warning message as below

APT_combinedOperatorController,1: Conversion Error calling conversion routine decimal_from_decimal data may have been lost.

How to eliminate this warning, is there any way?

Please Suggest. Highly appreciate your help.

Thanks

rkashyap · Post by **rkashyap** » Wed Jul 15, 2015 6:51 pm

The warning that system is giving is valid. If you are confident that data will fit into smaller target field, then you can suppress warning by using Modify stage for type conversion with an additional specification 'NOWARN'.

Code: Select all

Specification=OUTNUM:Decimal[9,4]=decimal_from_decimal(INNUM)
Specification=NOWARN

chulett · Post by **chulett** » Wed Jul 15, 2015 9:29 pm

Interesting. That or go all Old School on it and just demote the thing.