Skip to main content

Netezza Interview Questions and Answers

Question and Answer What the utilities available in nz/bin? Driver: libnzodbc.so , Utilities  : nzconvert, nzds, nzevent, nzhw, nzload, nzodbcsql, nzpassword, nzreclaim, nzrev, nzsession, nzsql, nzstate, nzstats, nzsystem Where is the Configuration file available? Config file odbc.ini is available in nz/lib and it contains the Database Source properties and Connection parameters. What is NZSQL utility? This utility can be run from any machine on which it is installed i.e. it does not have be from netezza box itself. This utility can be used to run any sql statement like select or insert statement on the netezza database. In the below usage you see data extracted from the table into a output file and in the second mzsql command the data is also gzipped. nzsql -host <netezz_db_servername> -d <database> -u <username> -pw <password> -c -c "select * from tablename" -o /root/home/outputfilename.txt; What is NZLOAD utility? This utility can be us
Post a Comment

NETEZZA SYLLABUS

NETEZZA PERFORMANCE SERVER
  1. INTRODUCTION
  2. NPS ARCHITECTURE
  3. INTRODUCTIONS TO TOOLS
  4. PERFORMANCE SERVER ADMINISTRATOR (INTRODUCTION)
  5. INTRODUCTION TO NPS ENVIRONMENT
  6. DATABASE , TABLES , SYNONYMS, VIEWS
  7. UDX (UDF AND UDA)
  8. ZONE MAPS and EXTENTS
  9. DATA DISTRIBUTION 
  10. DATA TYPES
  11. SEQUENCES
  12. TRANSACTIONS
  13. LOADING AND UNLOADING TABLES (NZLOAD , EXTERNAL TABLES)
  14. GENERATE STATISTICS
  15. OPTIMIZER AND QUERY PLAN
  16. MATERIALIZED VIEW
  17. NZRECLAIM - GROOMING
  18. BACKUP AND RESTORE
  19. LOADING DATA USING SSIS PACKAGES
Location: Bengaluru, Karnataka, India

Comments

Post a Comment

Popular posts from this blog

Creating Netezza User Defined Functions in C++

STEPS TO CREATE NETEZZA UDF For creating UDF in netezza we should have knowledge of C++ programming. The post explains how to create netezza UDF which finds greater value out of two values passed. STEP 1 : Write C++ code for the function. The code refers the the below header files. #include "udxinc.h" #include "udxhelpers.h"   And namespace list is mentioned below using namespace nz :: udx :: dthelpers; using namespace nz :: udx; The sample code for the greater of two numbers is mentioned below. #include "udxinc.h" #include "udxhelpers.h" #include <ctype.h> using namespace nz::udx; class greaterOfTwo : public Udf {   public :     static Udf* instantiate();     virtual ReturnValue evaluate()     {       int64 first = int64Arg(0);       int64 second = int64Arg(1);       int64 returnValue = 0;       if (first > second) returnValue = first; else returnValue = second;       NZ_UDX_RETURN_INT64(returnValue);     } }; Udf*
Post a Comment
Read more

Srquences in Netezza

A sequence is a named object in a database or schema that supports the get next value method. By using sequences, you can generate unique numbers that can be used as surrogate key values for primary key values, where the identification of rows within a table would involve a large, compound primary key, or for other purposes. A sequence value is an integer that you can use wherever you would use numeric values. IBM® Netezza® supports user sequences for the four integer types: byteint, smallint, integer, and bigint. You create a sequence with an initial value, an increment, a minimum, and a maximum value. You also specify whether the sequence cycles, which determines whether the sequence starts over when the endpoint is reached. Create a sequence Use the CREATE SEQUENCE statement to create a sequence, which is an object from which users can generate unique numbers. To create a sequence, use the CREATE SEQUENCE statement and specify the options in any order. CREATE SE
Post a Comment
Read more

Netezza Interview Questions and Answers

Question and Answer What the utilities available in nz/bin? Driver: libnzodbc.so , Utilities  : nzconvert, nzds, nzevent, nzhw, nzload, nzodbcsql, nzpassword, nzreclaim, nzrev, nzsession, nzsql, nzstate, nzstats, nzsystem Where is the Configuration file available? Config file odbc.ini is available in nz/lib and it contains the Database Source properties and Connection parameters. What is NZSQL utility? This utility can be run from any machine on which it is installed i.e. it does not have be from netezza box itself. This utility can be used to run any sql statement like select or insert statement on the netezza database. In the below usage you see data extracted from the table into a output file and in the second mzsql command the data is also gzipped. nzsql -host <netezz_db_servername> -d <database> -u <username> -pw <password> -c -c "select * from tablename" -o /root/home/outputfilename.txt; What is NZLOAD utility? This utility can be us
Post a Comment
Read more