General posts

General

Teradata Architecture – Components of Teradata

The biggest strength of Teradata and Netezza data warehouse appliance (RDBMS) is parallel processing. Just like Netezza architecture, Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The Teradata is made up of Parsing Engine, BYNET and Access Module Processors (AMPs) and other components such as nodes. Teradata is inexpensive, high-quality system that exceeded the performance of conventional relational database management systems. Read: Commonly used Teradata Date Functions and Examples Teradata Analytics Functions and Examples Teradata Set Operators: UNION, UNION ALL, INTERSECT, EXCEPT/MINUS Teradata Architecture – Components of Teradata…

Continue ReadingTeradata Architecture – Components of Teradata
Comments Off on Teradata Architecture – Components of Teradata
August 29, 2017
General

Database ACID Properties and Explanation

ACID (Atomicity, Consistency, Isolation, Durability) is a set of database properties that makes sure that database transactions are processed reliably and completly. Relational databases makes sures that its transactions are completed propely as per ACID properties . Database ACID Properties Following sections explains about various database ACID properties: Atomicity In ACID properties, Atomicity requires that each and every transaction is fully completed and committed or nothing at all. If any one part of the current transaction fails, then the entire transaction fails, and the database state is left unchanged (databse…

Continue ReadingDatabase ACID Properties and Explanation
Comments Off on Database ACID Properties and Explanation
June 3, 2017
General

Netezza SQL Interview Questions and Explanation

Below are some of best Netezza SQL interview questions that you may face: How do you improve performance of SQL queries? There are various options that you can use to improve the performance of Netezza queries. Read below post for all SQL optimization options. Steps to Optimize SQL Query Performance – Best Practices How to calculate the Cumulative Sum in Netezza? You can make use of the Netezza analytical functions to calculate the cumulative sum or running sum. Read: Netezza Cumulative Sum, Average and Example How do you Identify and…

Continue ReadingNetezza SQL Interview Questions and Explanation
1 Comment
May 21, 2017
General

Python File Word Count using Dictionary

Dictionaries are one of the best data types introduced in the Python. The dictionary holds data in form on Key:value pair. In this article, will present you the solution to Python File Word Count using Dictionary. Text File Acquire the text file from which you want to count repetition of each and every word. For the testing purpose, create any file with some of your favourite story or anything. Python File Word Count using Dictionary Let's work step by step on building this game. In this program, we are going…

Continue ReadingPython File Word Count using Dictionary
Comments Off on Python File Word Count using Dictionary
March 29, 2017
General

Search for String Pattern in Netezza Database: Google Like Search

Have you ever wondered how to search for string pattern in Netezza database? Here is one of the method that I used in our organisation to search for string pattern in Netezza database. This is process will take bit time to search full Netezza database. Here we have used the current_catalog to search for string pattern in current database. You can pass the database name and string pattern as a form parameter if you have any front end. You can build the query and get the desired results. Read: Netezza…

Continue ReadingSearch for String Pattern in Netezza Database: Google Like Search
Comments Off on Search for String Pattern in Netezza Database: Google Like Search
November 5, 2016
General

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…

Continue ReadingNetezza Cumulative Sum, Average and Example
Comments Off on Netezza Cumulative Sum, Average and Example
November 5, 2016
General

Identify and Remove Netezza Duplicate Records in Table

Netezza do not have primary or unique key. You can insert the duplicate records in the table. There are no constraints to ensure uniqueness or primary key, but if you have a table and have loaded data twice, then you can de-duplicate in several ways. Below methods explain you how to identify and Remove Netezza Duplicate Records Read: Netezza Pivot Rows to Column with Example Netezza Primary Key Constraint and Syntax 1. Use Intermediate and DISTINCT Keyword You can remove the Netezza duplicate records by creating another table using DISTINCT…

Continue ReadingIdentify and Remove Netezza Duplicate Records in Table
Comments Off on Identify and Remove Netezza Duplicate Records in Table
October 11, 2016
General

IBM Bluemix Speech TO Text Transcription in Python – Tutorial

Speech recognition and sentimental analysis are very important part of machine learning. In this tutorial, we will learn IBM Bluemix Speech to Text Transcription file in Python and copy those files to Hadoop ecosystem for further analysis. Once you have data in HDFS format you can torture the data to get the desired results. In this post will walk you through creating speech to text transcription file using IBM Bluemix and copy that file to Hadoop HDFS. IBM Bluemix Speech to Text Transcription in Python - Steps Below are the…

Continue ReadingIBM Bluemix Speech TO Text Transcription in Python – Tutorial
2 Comments
October 1, 2016
General

Netezza Pivot Rows to Column With Example

There may be a situation you may want PIVOT rows to column and vice versa. Netezza don't have PIVOT function like other RDBMS. Netezza Pivot rows to column and column to row requires the CASE or DECODE statements. Netezza PIVOT Rows to Column Let us consider the below input data TRAINING.ADMIN(ADMIN)=> select * from students; CLASS | SECTION | PASS_FAIL | COUNT --------+---------+-----------+------- CLASS2 | B | FAIL | 333 CLASS2 | B | PASS | 543 CLASS1 | A | FAIL | 123 CLASS1 | A | PASS |…

Continue ReadingNetezza Pivot Rows to Column With Example
1 Comment
September 11, 2016
General

Quick and best way to Compare Two Tables in SQL

Say you have requirement to compare two tables. You have two tables in same database or server that you wish to compare, and check if any changes in the column values or see if any row is missing in either of tables. Below are some of the methods you can use to compare two tables in SQL. Compare Two Tables using UNION ALL UNION allows you to compare data from two similar tables or data sets. It also handles the NULL values to other NULL values which JOIN or WHERE…

Continue ReadingQuick and best way to Compare Two Tables in SQL
Comments Off on Quick and best way to Compare Two Tables in SQL
August 29, 2016