This article describes the principal changes of IBM Netezza Templates.
The download section can be found at this page.
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
New Template "LOAD XML to Netezza"
A new dedicated Template has been added for loading data from XML files into Netezza using Netezza External tables.
This Template allows to load data into Netezza more effciency than the generic xml load Template.
Reject rules which are defined with "warning" severity level in Metadata should not be removed from the flow and should be loaded in target table.
Previous version of the Template was unexpectedly removing rejected rows with "warning" severity level from the flow, which was wrong, and which has been fixed from this version.
Rows which does not fulfill a rule which has been specified with "warning" severity level will not be kept in the flow and loaded into target table.
STAGING Netezza As Table
"set catalog" statement which is executed before queries was using the catalog of the work schema instead of the catalog of the stage's schema.