Netezza Utilities

The 2 frequently used Netezza Utilities are as follows

NZSQL and NZLOAD

The nzload command returns three status codes. They are

• 0: Nzload command is success and the data is loaded into the target table.
• 1: Nzload command is success. However errors are occurred in loading. But the number of errors does not exceeded the -maxErrors option
• 2: Nzload command failed

Let's see how to create a generic script and pass the sql script from file to the generic script.

How to call this script in Informatica command task and pass the SQL script file name as parameter.

Lets first create a generic script for the following operations. 

1)Select 

2)Insert 

3)Delete

4)Update

To make the script generic we need to have a profile file which hold the parameter file values need for the script.

Lets see how the above values will be used in the script

Lets see how to call this script from informatica command task

Lets see the PROD_DIM_SQL Script, that we are passing as parameter in the above example.

In netezza :WH_DBNAME act as parameter
: is the syntax for defining a parameter (similar to "$" is the syntax for shell script or Teadata bteq Script)