Decimal size limitation in Terdata
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Data Warehousing » Decimal size limitation in Terdata
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Decimal size limitation in Terdata Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
vineet
Posted 3/3/2008 4:13:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/17/2008 7:53:25 AM
Posts: 7, Visits: 50
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,
Post #10769
Fred Pluebell
Posted 3/3/2008 10:02:55 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: PAC and SFT Members
Last Login: Yesterday @ 11:52:39 PM
Posts: 303, Visits: 420
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.
Post #10773
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 3 ( 3 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 2:53am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 7 queries. Compression Disabled.