Decimal size limitation in Terdata

UDA
Enthusiast

Decimal size limitation in Terdata

In teradata, the numbers cannot be greater then (18,3). I have some data in my Oracle source tables which has a size of DECIMAL(22,7).
So if i push this data to Teradata Target table, then what will happen to this data,the teradata loader would neglect this data or truncate data of this size ?

Thanks in advance,
1 REPLY
Teradata Employee

Re: Decimal size limitation in Terdata

Teradata V2R6.2 and later allow up to DECIMAL(38). But to answer your question, values will be rounded to fit in the number of decimal places defined.