All Forums UDA
vineet 7 posts Joined 01/08
03 Mar 2008
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,

Fred 1096 posts Joined 08/04
03 Mar 2008

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.

You must sign in to leave a comment.