Cloud Data Integration for PowerCenter
- Cloud Data Integration for PowerCenter
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Data
Type
| Size in Bytes
| Description
|
|---|---|---|
Array
| Unlimited number of characters.
| Complex data type.
You can use arrays with complex sources and targets.
|
Bigint
| 8 bytes
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision of 19, scale of 0
Integer value.
|
Binary
| Precision
| 1 to 104,857,600 bytes
You cannot use binary data for flat file sources.
|
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.
|
Decimal
| 8 bytes (if high precision is off or precision is greater than 38)
16 bytes (if precision <= 18 and high precision is on)
20 bytes (if precision > 18 and <= 28)
24 bytes (if precision > 28 and <= 38)
| 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.
|
Double
| 8 bytes
| Double-precision floating-point numeric value.
You can edit the precision and scale. The scale must be less than or equal to the precision.
|
Integer
| 4 bytes
| -2,147,483,648 to 2,147,483,647
Precision of 10, scale of 0
Integer value.
|
Map
| Unlimited number of characters.
| Complex data type.
You can use maps with complex sources and targets.
|
String
| Unicode mode: (precision + 1) * 2
ASCII mode: precision + 1
| 1 to 104,857,600 characters
Fixed-length or varying-length string.
|
Struct
| Unlimited number of characters.
| Complex data type
You can use structs with complex sources and targets.
|
Text
| Unicode mode: (precision + 1) * 2
ASCII mode: precision + 1
| 1 to 104,857,600 characters
Fixed-length or varying-length string.
|
timestampWithTZ
| 40 bytes
| 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:
|
