Saturday, 7 February 2015

Teradata Data Types - Using in BI Projects

Teradata JOBS
Currently Teradata supports different data types.

  • BYTEINT ==> Signed whole number ==> -128 to 127

  • CHAR ==> Character String  ==> 1to 64000 bytes. The disadvantage is it pads spaces, when you do not give that much string length

  • VARCHAR ==> Character string ==> Only it occupies space, the string length you have given

  • DATE ==>  DATE type  ==> YYYYMMDD format

  • TIME ==> Time value will be stored ==> HH:MM:SS

  • INTEGER ==>Signed whole number ==>   -2,147,483,648 to 2,147,483,647

  • SMALLINT ==> Signed small whole number ==> -32,768 to 32,767

  • DEC ==> Signed decimal number ==> 18 digits on either side ==> DEC(18,0)-Max and DEC(18,18)-small
There are other data types. Keep reading in my next posts.
Read more
 

No comments:

Post a Comment