Some recent research to eliminate some ETL Data Conversion issues made me want to enhance the documentation provided by IBM, to prevent repeating the research.
Netezza data types and their equivalent InfoSphere DataStage data types
Netezza data types |
InfoSphere DataStage data types (SQL types) |
Notes | |
BYTEINT | TinyInt | ||
SMALLINT | SmallInt | ||
INT | Integer | ||
BIGINT | BigInt | ||
NUMERIC(p, s) | Numeric, decimal, double | Decimal and double are aliases of Numeric | |
FLOAT(p) | Float | ||
REAL | Real | ||
DOUBLE PRECISION | Double | ||
CHAR(n) | Char | ||
VARCHAR(n) | VarChar | ||
NCHAR(n) | NChar | ||
NVARCHAR(n) | NVarChar | ||
BOOLEAN | Bit | ||
DATE | Date | ||
TIME | Time | ||
TIME WITH TIME ZONE | VarChar | The value of time with time zone will be returned without the time zone information. | |
TIMESTAMP | TimeStamp | ||
INTERVAL | VarChar | You cannot load the interval data type from an external table. | |
ROWID | BigInt | ||
TRANSACTION ID | BigInt | ||
DATASLICE | Integer |