PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.5.4
- All Products
Amazon Redshift Data Type
| Amazon Redshift Data Type Aliases
| Description
| Transformation Data Type
|
---|---|---|---|
Smallint
| Int2
| Signed two-byte integer.
| Small Integer
|
Integer
| Int, Int4
| Signed four-byte integer.
| Integer
|
Bigint
| Int8
| Signed eight-byte integer.
| Bigint
|
Decimal
| Numeric
| Exact numeric of selectable precision.
| Decimal
|
Real
| Float4
| Single precision floating-point number.
| Double
|
Double Precision
| Float8, Float
| Double precision floating-point number.
| Double
|
Boolean
| Bool
| Logical Boolean (true/false).
| Small Integer
|
Char
| Character, Nchar, Bpchar
| Fixed-length character string.
| String
|
Varchar
| Character Varying, Nvarchar, Text
| Variable-length character string with a user-defined limit.
| String
|
Date
| NA
| Calendar date (year, month, day).
| Timestamp
|
Timestamp
| Timestamp without time zone
| Date and time (without time zone).
| Timestamp
|
Timestampz
| Timestamp with time zone
| Date and time (with time zone).
| Timestamp
|