PowerCenter
- PowerCenter 10.4.0
- All Products
Transformation Datatype | IBM DB2 | Microsoft SQL Server | Oracle | Sybase ASE | Teradata | Informix |
---|---|---|---|---|---|---|
bigint | bigint | bigint | number(19,0) | bigint | bigint | int8 |
binary | char for bit data | binary | raw | binary | byte/varbyte | byte |
date/time | timestamp | datetime | timestamp | datetime | timestamp | datetime year to fraction |
decimal | decimal | decimal | number(p,s) | decimal | decimal | decimal(p,s) |
double | float | float | number | float | float | float(p) |
integer | integer | int | number(p,s) | int | integer | integer |
nstring | vargraphic | nvarchar | nvarchar2 | nvarchar | n/a | nvarchar |
ntext | long vargraphic | ntext | nclob | nvarchar | n/a | n/a |
real | float | real | number | real | n/a | smallfloat |
small integer | smallint | smallint | smallint | smallint | smallint | smallint |
string | varchar | varchar | varchar2 | varchar | varchar | varchar(m,r) |
text | long varchar | text | long | text | n/a | text |