InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 18:27:49 GMT20http://www.teradata.com/teradataforum/Topic11061-1-1.aspxThe source datatype is "MONEY" in SQL Server with Length=8, Precision=19, Scale=4. Pls let me know which is the corresponding datatype in Teradata V12 for this "MONEY" datatype.thanx in advance.Fri, 28 Mar 2008 05:32:19 GMTRakesh nchttp://www.teradata.com/teradataforum/Topic11061-1-1.aspxDecimal(18) takes up 8 bytes while Decimal(19) through Decimal(38) takes up 16 bytes.See SQL Reference: Data Types and Literals.Is the source data/field 16 bytes long?Thu, 27 Mar 2008 14:52:39 GMTShawhttp://www.teradata.com/teradataforum/Topic11061-1-1.aspxI was previously using Teradata Version 6 and we used to fastload data into tables with fields, decimal(18,4). Now we have shifted to Teradata Version 12 and requirement is that the tables should have decimal(19,4) fields. I get the following error when I try to fastload data into a decimal field(19,4), "DECIMAL TYPE- record too short".However when I try to fastload with decimal(18,4) in Teradata Version 12, it runs just fine. So could someone please help me with this.Thu, 27 Mar 2008 01:59:18 GMTRakesh nc