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
Decimal_From_Decimal Warning Issue
Moderators: chulett, rschirm, roy
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