InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 20:47:58 GMT20http://www.teradata.com/teradataforum/Topic10769-1-1.aspxTeradata 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.Mon, 03 Mar 2008 10:02:55 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic10769-1-1.aspxIn 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,Mon, 03 Mar 2008 04:13:23 GMTvineet