PowerCenter
- PowerCenter 10.4.1
- All Products
Datatype | Transformation | Range |
---|---|---|
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 |
Bit | String | 1 to 104,857,600 characters |
Char(L) | 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) |
Decimal(P, S) | Decimal | Precision 1 to 28, scale 0 to 28 |
Double | Double | Precision 15 |
Float | Double | Precision 15 |
Integer | Integer | -2,147,483,648 to 2,147,483,647 Precision 10, scale 0 |
Long Varbinary | Binary | 1 to 104,857,600 bytes |
Nchar | Nstring | 1 to 104,857,600 characters |
Nvarchar | Nstring | 1 to 104,857,600 characters |
Ntext | Ntext | 1 to 104,857,600 characters |
Numeric | Decimal | Precision 1 to 28, scale 0 to 28 |
Real | Real | Precision 7, scale 0 |
Smallint | Smallint | Precision 5, scale 0 |
Text | Text | 1 to 104,857,600 characters |
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 | Small Integer | Precision 5, scale 0 |
Varbinary | Binary | 1 to 104,857,600 bytes |
Varchar(L) | String | 1 to 104,857,600 characters |