Netezza

Netezza nzsql Exit Codes for UNIX/Linux Systems

In this article, Netezza nzsql exit codes are discussed. These exit codes are very much important when you are building ETL/ELT operation using shell scripts. On UNIX/Linux systems such as the NPS, the Netezza nzsql exit codes provide information about the execution status of the SQL commands. Read: Netezza nzsql Command and its Usage Netezza SET ON_ERROR_STOP and Examples Netezza nzsql Exit Codes When you are running queries interactively at the nzsql prompt or by using a script (nzsql -f), the command returns one of the following exit codes: 0:…

Continue ReadingNetezza nzsql Exit Codes for UNIX/Linux Systems
Comments Off on Netezza nzsql Exit Codes for UNIX/Linux Systems
December 30, 2016
BigData

Hadoop HDFS Architecture Introduction and Design

In this post you will learn about the Hadoop HDFS architecture introduction and its design. The Hadoop Distributed File System (HDFS) is a Java based distributed file system, designed to run on commodity hardwares. It has many similarities with existing available distributed file systems. Hadoop HDFS Architecture Introduction HDFS is highly fault-tolerant and is designed to be deployed on low-cost hardware. Hadoop HDFS provides high throughput access to application data and is suitable for applications that have large volume of data sets. HDFS has demonstrated production scalability of up to…

Continue ReadingHadoop HDFS Architecture Introduction and Design
Comments Off on Hadoop HDFS Architecture Introduction and Design
December 3, 2016
Data Warehouse

Data Warehouse Fact Constellation Schema and Design

Basically, Data warehouse fact constellation schema is viewed as a collection of many star schemas. For each star schema or snowflake schema it is possible to create Fact Constellation schema. This schema is one of the widely used data warehouse design methodology and is also called Galaxy schema. Sophisticated application required the Fact constellation schemas. Read: Star Schema model in Data Warehouse Snowflake Schem Model in Data Warehouse Step by Step Guide to Dimensional Data Modeling Slowly Changing Dimensions (SCD) in Data Warehouse Rapidly Changing Dimension in Data Warehouse Representation…

Continue ReadingData Warehouse Fact Constellation Schema and Design
Comments Off on Data Warehouse Fact Constellation Schema and Design
December 3, 2016
Netezza

Different types of Netezza Trim Functions and Examples

The Netezza TRIM functions which are available in Netezza NZSQL are used to remove specified prefix or suffix from a string. The most common pattern being removed is white spaces. Netezza support different trim function that you can be used to trim or remove the particular character or white spaces. A Netezza trim functions includes TRIM, LTRIM, and RTRIM. Read: Netezza String Functions and Examples Netezza LEFT and RIGHT Functions and Examples IBM Netezza Analytical Functions How to use Netezza Replace Function and Examples Netezza Array Functions and Examples Netezza…

Continue ReadingDifferent types of Netezza Trim Functions and Examples
Comments Off on Different types of Netezza Trim Functions and Examples
December 2, 2016
Netezza

Netezza Dual Table Alternative

If you have come from the Oracle database background then you will be confusing and frustrating to find there is no Netezza dual table. In Netezza you do not need one; believe me when I am saying you do not need dual in Netezza. When you are working on MPP appliance like Netezza, you can run your SQL queries or calculations without any dummy table i.e. dual table oracle. Read: Netezza Alter Table Commands and Examples Netezza LIKE Statement and Pattern matching Examples IBM Netezza Split Delimited Fields into Table…

Continue ReadingNetezza Dual Table Alternative
Comments Off on Netezza Dual Table Alternative
December 1, 2016
Netezza

Netezza LIKE Statement and Pattern matching Examples

Unlike any other database, Netezza nzsql supports the pattern matching. You can search for the string by matching particular patterns. The Netezza LIKE statement expression is most commonly used in pattern matching. The Netezza LIKE statement returns true if the string contained in the set if strings or table columns that are represented by the pattern. The Netezza NOT LIKE statement returns false if LIKE returns true and vise-versa. Read: Netezza Phonetic Matching Functions and Examples Netezza Fuzzy String search Functions and Examples Search for String Pattern in Netezza Database:…

Continue ReadingNetezza LIKE Statement and Pattern matching Examples
Comments Off on Netezza LIKE Statement and Pattern matching Examples
November 29, 2016
Netezza

Netezza Array Functions and Examples

Netezza Appliance does not support the Netezza array functions without Netezza SQL Extension tool kit. You have to install the tool kit explicitly on the required data type. Read: Guide to Download and install Netezza SQL Extension Tool kit Netezza Data Types and Restrictions Netezza String Functions and Examples IBM Netezza Extract Function and its Usage Different types of Netezza Trim Functions and Examples These Netezza Array functions available in the toolkit rely on the Netezza array data type. IBM Netezza does not support the user defined data types, array…

Continue ReadingNetezza Array Functions and Examples
Comments Off on Netezza Array Functions and Examples
November 27, 2016
Netezza

Netezza Split Delimited Fields into Table Records and Examples

If you are working on the large volume of different source system then you may come across the requirement of Netezza split delimited fields into table records. There are some methods those you can use as per your requirements: Netezza Split Delimited Fields using ARRAY_SPLIT function You can use the ARRAY_SPLIT function that strips off record delimiter. The Netezza array functions are available in Netezza SQL extension tool kit that you have to install explicitly on required database. Read: Netezza String Function and its Usage with Examples Netezza Array Functions…

Continue ReadingNetezza Split Delimited Fields into Table Records and Examples
Comments Off on Netezza Split Delimited Fields into Table Records and Examples
November 26, 2016
Netezza

Netezza Fuzzy String search Functions and Examples

If you ever wondered how to verify how similar or different strings are. The Netezza SQL language supports two Netezza fuzzy string search functions:  Levenshtein Edit Distance and Damerau-Levenshtein Edit Distance. You can perform the fuzzy search with help of these functions. Basically, Netezza fuzzy string search function supports a search in a form of approximate string matching that is based on the defined technique or algorithms. These functions compare two strings to show how similar or different they are. These two fuzzy functions support only VARCHAR or CHAR data…

Continue ReadingNetezza Fuzzy String search Functions and Examples
Comments Off on Netezza Fuzzy String search Functions and Examples
November 25, 2016
Netezza

Netezza User Defined Functions and Sample Examples

The Netezza user defined functions feature allows you to create custom functions, aggregates, and shared libraries that run on Netezza systems and perform specific types of analysis for your business reporting and data query using those UDFs. The Netezza user defined functions allows you to make use of the Netezza massively parallel processing (MPP) environment to accelerate or speed up your data analysis, as well as to offer new and unique types of analysis on you tera byte of data. Read: Netezza Advance Analytics Functions Netezza String Functions and Examples…

Continue ReadingNetezza User Defined Functions and Sample Examples
Comments Off on Netezza User Defined Functions and Sample Examples
November 25, 2016