Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Teradata and Transformation Datatypes

Teradata and Transformation Datatypes

The following table compares Teradata datatypes and transformation datatypes:
Teradata
Range
Transformation
Range
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Byte
1 to 64,000 bytes
Binary
1 to 104,857,600 bytes
Byteint
-128 to 127
Small Integer
Precision 5, scale 0
Char
1 to 64,000 bytes
String
1 to 104,857,600 characters
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 19, scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal
Precision 1 to 18, scale 0 to 18
Decimal
Precision 1 to 28, scale 0 to 28
Float
-2.226E+308 to 1.797E+308
Double
Precision 15
Integer
-2,147,483,648 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Smallint
-32768 to 32768
Small Integer
Precision 5, scale 0
Time
00:00:00.000000 to 23:59:61.999999
Precision 8, scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
1 to 19 characters
Precision 19 to 26, scale 0 to 6
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Varbyte
1 to 64,000 bytes
Binary
1 to 104,857,600 bytes
Varchar
1 to 64,000 bytes
String
1 to 104,857,600 characters


Updated July 02, 2020