PowerCenter
- PowerCenter 10.5
- All Products
Oracle
| Range
| Transformation
| Range
|
---|---|---|---|
Blob | Up to 4 GB | Binary | 1 to 104,857,600 bytes |
Char(L) | 1 to 2,000 bytes | String | 1 to 104,857,600 characters |
Clob | Up to 4 GB | Text | 1 to 104,857,600 characters |
Date | Jan. 1, 4712 B.C. to Dec. 31, 4712 A.D. Precision 19, scale 0 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Long | Up to 2 GB | Text | 1 to 104,857,600 characters If you include Long data in a mapping, the Integration Service converts it to the transformation String datatype, and truncates it to 104,857,600 characters. |
Long Raw | Up to 2 GB | Binary | 1 to 104,857,600 bytes |
Nchar | 1 to 2,000 bytes | Nstring | 1 to 104,857,600 characters |
Nclob | Up to 4 GB | Ntext | 1 to 104,857,600 characters |
Number | Precision of 1 to 38 | Double | Precision of 15 |
Number(P,S) | Precision of 1 to 38, scale of 0 to 38 | Decimal | Precision of 1 to 28, scale of 0 to 28 |
Nvarchar2 | 1 to 4,000 bytes | Nstring | 1 to 104,857,600 characters |
Raw(L) | 1 to 2,000 bytes | Binary | 1 to 104,857,600 bytes |
Timestamp | Jan. 1, 4712 B.C. to Dec. 31, 9999 A.D. Precision 19 to 29, scale 0 to 9 (precision to the nanosecond) | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Varchar(L) | 1 to 4,000 bytes | String | 1 to 104,857,600 characters |
Varchar2(L) | 1 to 4,000 bytes | String | 1 to 104,857,600 characters |
XMLType based CLOB storage | Up to 4 GB | Text | 1 to 104,857,600 characters |