Infosphere Datastage – Data type conversions from Netezza to DataStage

Some recent research to eliminate some ETL Data Conversion issues, made me want to make an enhancement to 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

 
BYTEINTTinyInt  
SMALLINTSmallInt  
INTInteger  
BIGINTBigInt  
NUMERIC(p, s)Numeric, decimal, doubleDecimal and double are aliases of Numeric 
FLOAT(p)Float  
REALReal  
DOUBLE PRECISIONDouble  
CHAR(n)Char  
VARCHAR(n)VarChar  
NCHAR(n)NChar  
NVARCHAR(n)NVarChar  
BOOLEANBit  
DATEDate  
TIMETime  
TIME WITH TIME ZONEVarCharThe value of time with time zone will be returned without the time zone information. 
TIMESTAMPTimeStamp  
INTERVALVarCharYou cannot load the interval data type from an external table. 
ROWIDBigInt  
TRANSACTION IDBigInt  
DATASLICEInteger  

Related References

Data type conversions from Netezza to DataStage

InfoSphere Information Server, InfoSphere Information Server 11.5.0, Connecting to data sources, Databases, Netezza Performance Server, Netezza connector, Designing jobs by using the Netezza connector, Defining a Netezza connector job, Data type conversions, Data type conversions from Netezza to DataStage