The 2 frequently used Netezza Utilities are as follows NZSQL and NZLOAD
The nzload command returns three status codes. They are
How to call this script in Informatica command task and pass the SQL script file name as parameter.
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)