Table of Contents

Search

  1. Preface
  2. Introduction to Intelligent Streaming
  3. Intelligent Streaming Configuration
  4. Connections
  5. Sources and Targets in a Streaming Mapping
  6. Intelligent Streaming Mappings
  7. Window Transformation
  8. Data Type Reference

Flat Data Types

Flat Data Types

The following table lists the Flat data types that Data Integration Service supports and the corresponding transformation data types::
Flat Data Type
Transformation Type
Description
bigint
The elements in the array are of string data type. The elements in the array are delimited by commas. For example, an array of fruits is represented as [apple,banana,orange]
datetime
Date/Time
16 bytes Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision of 29, scale of 9 (precision to the nanosecond) Combined date/time value.
number
double
Decimal value with declared precision and scale. Scale must be less than or equal to precision.
For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28. If you specify the precision greater than the maximum number of digits, the Data Integration Service converts decimal values to double in high precision mode.
int
integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
nstring
string
1 to 104,857,600 characters
string
1 to 255 characters
timestampWithTZ
Aug. 1, 1947 A.D to Dec. 31, 2040 A.D. -12:00 to +14:00 Precision of 36 and scale of 9. (precision to the nanosecond) Timestamp with Time Zone data type does not support the following time zone regions:- AFRICA_CAIRO- AFRICA_MONROVIA- EGYPT- AMERICA_MONTREAL