Infosphere DataStage – Boolean Handling for Netezza

  Beware when you see this message when working with Boolean in DataStage, the message displays as informational (at list it did for me) not as a warning or an error.  Even though it seems innocuous, what it meant for my job, was the Boolean (‘true’ / ‘false’) was not being interpreted and everything posted … Continue reading Infosphere DataStage – Boolean Handling for Netezza

Infosphere Datastage – Data type conversions from Netezza to DataStage

IBM Infosphere Information Server (IIS) 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 … Continue reading Infosphere Datastage – Data type conversions from Netezza to DataStage

Netezza / PureData – What is the maximum length of CHAR, VARCHAR, and NVARCHAR fields

IBM Netezza / IBM PureData for Analytics During a recent project, I had reason to investigate what the maximum character field links for Netezza to be able to fit the data ETL ‘ed from the source.  The constraints on Netezza character fields are not as long as some other databases, therefore, I thought I would … Continue reading Netezza / PureData – What is the maximum length of CHAR, VARCHAR, and NVARCHAR fields