PowerExchange Adapters for PowerCenter
- PowerExchange Adapters for PowerCenter 10.4.0
- All Products
Vertica Data Type
| Transformation Data Type
| Description
|
---|---|---|
Bigint
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Binary
| Binary
| 1 to 104,857,600 bytes
|
Boolean
| String
| 1 to 104,857,600 characters
|
Bytea
| Binary
| 1 to 104,857,600 bytes
|
Char
| String
| 1 to 104,857,600 characters
|
Date
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Datetime
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Decimal
| Decimal
| Precision 1 to 28, scale 0 to 28
|
Double precision
| Double
| Precision 15
|
Float
| Double
| Precision 15
|
Float (N)
| Double
| Precision 15
|
Float8
| Double
| Precision 15
|
Int
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Int8
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Integer
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Interval
| String
| 1 to 104,857,600 characters
|
Money
| Numeric (P, S)
| Precision 1 to 28, scale 0 to 28
|
Number
| Decimal
| Precision 1 to 28, scale 0 to 28
|
Numeric
| Decimal
| Precision 1 to 28, scale 0 to 28
|
Raw
| Binary
| 1 to 104,857,600 bytes
|
Real
| Double
| Precision 15
|
Smalldatetime
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Smallint
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Time
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Timestamp
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Tinyint
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Varbinary
| Binary
| 1 to 104,857,600 bytes
|
Varchar
| String
| 1 to 104,857,600 characters
|