Data Engineering Integration
- Data Engineering Integration 10.5.1
- All Products
Flat File Data type
| Transformation Data type
| Range
|
---|---|---|
Bigint
| Bigint
| Precision of 19 digits, scale of 0
|
Datetime
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
|
Double
| Double
| Precision of 15 digits
|
Int
| Integer
| -2,147,483,648 to 2,147,483,647
|
Nstring
| String
| 1 to 104,857,600 characters
|
Number
| Decimal
| 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.
If the precision is greater than 15, the Data Integration Service converts decimal values to double in low-precision mode.
|
String
| String
| 1 to 104,857,600 characters
|
TimestampWithTZ
| 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:
TimestampWithTZ is applicable only to the native environment.
|