Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Teradata Parallel Transporter API
  3. PowerExchange for Teradata Parallel Transporter API Configuration
  4. PowerExchange for Teradata Parallel Transporter Connections
  5. PowerExchange for Teradata Parallel Transporter API Data Objects
  6. PowerExchange for Teradata Parallel Transporter API Mappings
  7. Teradata Parallel Transporter API Run-time Processing
  8. Data Type Reference

PowerExchange for Teradata Parallel Transporter API User Guide

PowerExchange for Teradata Parallel Transporter API User Guide

Teradata Data Types and Transformation Data Types

Teradata Data Types and Transformation Data Types

The following table lists the Teradata data types that the Data Integration Service supports and the corresponding transformation data types:
Teradata Data Type
Range
Transformation Data Type
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 15, scale 6
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
When you use Teradata mappings in a Blaze environment, you must convert Decimal, Date, Time, or Timestamp data types for the Teradata object to String data type in the Developer Tool. Byte and Varbyte data types are not supported in the Blaze environment.


Updated October 05, 2018