DWgeek.com

Netezza Cumulative Sum, Average and Example

You can make use of the Netezza analytical functions to calculate the cumulative sum or running sum. Sum and Average analytical functions are used along with window options to calculate the Netezza cumulative sum or running sum. Read: Identify and Remove Netezza Duplicate Records in Table IBM Netezza Extract Numbers from String Examples Netezza Pivot Rows to Column With Example Netezza Update Join Syntax and Examples Netezza Recursive Query Alternative and Examples IBM Netezza Rollup Group Aggregates using Grouping sets Netezza Cumulative Sum, Average Syntax: Below are the Syntax for…

Comments Off

November 5, 2016

Netezza

Basic Netezza Linux Commands to Learn Netezza

In this post you will learn about some basic Netezza Linux commands. As you know, Netezza is Linux based data warehouse appliance that doesn’t have any UI. To get started you need to know some basic Netezza Linux commands to move through the Linux directories, find files, find directory size, create folders, create folders, and use some standard file editor to create file. Read: Commonly used Netezza Basic Commands Basic Netezza Linux Commands Here are the quick and lists of basic Netezza Linux commands that are frequently used when working…

Comments Off

November 2, 2016

Netezza

Commonly used Netezza Basic Commands

In this post you will learn about some commonly day to day Netezza basic commands. There are lot of Netezza basic commands available along with Netezza commonly used utilities that are used but here are listed some commonly used commands. Read: Netezza Commonly used Utilities Basic Netezza Linux Commands to Learn Netezza nzrev Command Check the Netezza build version [nz@netezza01 ~]$ nzrev Release 7.2.1.0 [Build 46322] [nz@netezza01 ~]$ nzstats Command Provide the statistics about the Netezza appliance [nz@netezza01 ~]$ nzstats Field Name Value -------------------- -------------------------------------------- Name netezza 01 Description <sys…

Comments Off

November 1, 2016

Netezza

Netezza Failover – High Availability Architecture

Netezza appliance include necessary components to function seamlessly in the event of any hardware issue so that its availability is more that 99.99%. This is called Netezza high availability architecture that perform seamlessly in case of Netezza failover. There are two host in a cluster in all Netezza appliances so that if one fails other once can take over the task that is being carried out. Netezza Failover - High Availability Architecture Overview Netezza appliance uses the Linux-HA (high availability) and Distributed Replicated Block Device (DRBD) for the host cluster…

Comments Off

October 31, 2016

BigData

Basic Hadoop HDFS Filesystem Operations With Examples

There are many interfaces to HDFS available, but the command line (CLI) is one of the simplest and, to many developers, the most familiar interface. You can perform most advanced and basic Hadoop HDFS filesystem operations using CLI. Basic Hadoop HDFS Filesystem Operations The when Hadoop HDFS filesystem is set, you can do all of the basic HDFS filesystem operations, such as reading files, creating directories, moving files, deleting data, and listing directories. You can also perform the advance Hadoop HDFS filesystem operations such as updates, administrator from command line.…

Comments Off

October 31, 2016

BigData

Hadoop HDFS Schema Design for ETL Process

Now a day’s many organisations are using Hadoop for their ETL processing. In this post we will learn Hadoop HDFS Schema Design for ETL Process. In this section, you will learn about good schema design for data that you store in Hadoop HDFS directly. Hadoop HDFS Schema Design Overview Many organisation uses Hadoop for storing and processing unstructured, semi-structured or structured data. Hadoop is schema-on-read model that does not impose any requirements when loading data into Hadoop ecosystem. You can simply ingest data into Hadoop HDFS by using available ingestion…

Comments Off

October 26, 2016

BigData

Hadoop Data Warehouse and Design Considerations

A data warehouse, also known as an enterprise data warehouse (EDW), is a large collective store of data that is used to make such data-driven decisions, thereby becoming one of the centrepiece of an organization’s data infrastructure. Hadoop Data Warehouse was challenge in initial days when Hadoop was evolving but now with lots of improvement, it is very easy to develop Hadoop data warehouse Architecture. This article will server as a guide to Hadoop data warehouse system design. Hadoop data warehouse integration is now a days become very much popular…

Comments Off

October 26, 2016

Netezza

Netezza Backup and Restore: Best Practices

In this post you will learn about Netezza backup and restore data. It provides general information on backup and restore methods available with Netezza system. Netezza Backup and Restore Overview Netezza provides several backup and restore methods as per the different requirements. You can take table or database backup whenever required: You can create full and incremental backups of your various Netezza databases in compressed internal using the nzbackup command and restore them to a Netezza system whenever required using nzrestore command. As a best practice create script that perform…

Comments Off

October 25, 2016

Netezza

Netezza Pad Zero with Working Example

Netezza pad zero functions are string functions used to remove or add the string to beginning or end of the expression. An expression could be column values. There are two pad functions available in Netezza; LPAD and RPAD string functions. You can use those function in Netezza pad zero or any other character provided in arguments: Read: Netezza String Functions and Usage Different types of Netezza Trim Functions and Examples Netezza Date Functions and Examples nzsql Command and its Usage Netezza LPAD function You can use this function to pad string…

Comments Off

October 24, 2016

Netezza

Netezza Export Table Data to CSV format

You can export the Netezza table in many ways. Netezza export table is done using either Netezza external table or Netezza nzsql commands. Use of Netezza external table is fastest way to export Netezza table data compared to a Netezza nzsql command. Netezza nzsql with option -o is easy method compared to creating Netezza external tables. Netezza Export Table using Netezza External Tables You can use the Netezza transient external table to export the data table to flat file (CSV format). This feature is very handy if you are exporting…

4 Comments

October 21, 2016