Netezza

Netezza Just In Time (JIT) statistics

You might know how the Netezza generate statistics works and how to generate the stats on the tables. Read my other post Netezza generate statistics: Best Practices. In this post, we will discuss about the Netezza Just in Time (JIT) statistics. Netezza Just in Time (JIT) statistics The Netezza system automatically generates Just in Time (JIT) statistics on user tables to help the optimizer refine planning when you fire the query to Netezza system. Netezza JIT statistics comes handy when there is a skew in the table, it improves the…

Continue ReadingNetezza Just In Time (JIT) statistics
Comments Off on Netezza Just In Time (JIT) statistics
March 23, 2017
Netezza

Netezza External Table DATAOBJECT Option

In this article, we will discuss about the Netezza external table DATAOBJECT and REMOTESOURCE option and how these options work. You must specify these options in case if you are using separate Linux host or an edge node to connect to Netezza data warehouse appliance. Edge Node Background An edge node is something that most of the organisations uses to connect to Netezza server. The edge node will have the all the required scripts to perform the ETL or ELT operations. Normally, edge nodes are installed with JDBC, ODBC or…

Continue ReadingNetezza External Table DATAOBJECT Option
Comments Off on Netezza External Table DATAOBJECT Option
March 23, 2017
Netezza

Netezza SET CATALOG command: Connect to Different Database from same Session

If you are a business analyst or data architect then you have to work on the different database to identify the relevant data to come up with business decisions on a particular design. You can connect to multiple databases from the current Netezza sessions using Netezza SET CATALOG command Use the SET CATALOG command to connect to a different Netezza database in the same session. This command is the session specific i.e. as soon as the execution ends in current session; Netezza reverts back to the original database. Read: Commonly…

Continue ReadingNetezza SET CATALOG command: Connect to Different Database from same Session
Comments Off on Netezza SET CATALOG command: Connect to Different Database from same Session
March 9, 2017
Redshift

Redshift Install SSL Certificate in Local Windows System

Redshift SSL Certificates are small data files that digitally bind a cryptographic key to redshift cluster connection details. In this article, we will discuss on Redshift install SSL certificate in local system. Redshift SSL Certificate You have to login to AWS console to download the .pem file. To support SSL connections, Amazon Redshift creates and installs a self-signed SSL certificate on each cluster. To login to cluster, you should have an account created with Amazon AWS cloud. You can obtain the account by yourself or use the corporate account. The public…

Continue ReadingRedshift Install SSL Certificate in Local Windows System
Comments Off on Redshift Install SSL Certificate in Local Windows System
March 9, 2017
Netezza

Netezza Storing Large data files to Local Systems

If you are working as a data analyst or business analyst then you may have to download the files to your local for analysis purpose. In this article, we will discuss on Netezza storing large data files to local systems. If you have installed different Netezza SQL tools then it is very easy to store the large set of results to local system. Netezza Storing Large data files to Local Systems- Methods There are multiple methods that you can follow in Netezza Storing Large data files to Local Systems Windows…

Continue ReadingNetezza Storing Large data files to Local Systems
1 Comment
March 6, 2017
Redshift

Resolution: Amazon Redshift Drop and Truncate Table Running Slow

Sometimes Amazon Redshift takes hours together to just drop or truncate the tables even if table has very limited rows. In this article, I have put together the steps I usually follow when Amazon Redshift Drop and Truncate Table Running Slow. Amazon has a very fast I/O; it should not take more than second to drop or truncate the tables for any cluster type that you are using. This issue is because there might be more connections with open transactions. Follow below steps: Check for DB locks You can check…

Continue ReadingResolution: Amazon Redshift Drop and Truncate Table Running Slow
Comments Off on Resolution: Amazon Redshift Drop and Truncate Table Running Slow
March 4, 2017
Netezza

Netezza Integer Value Check

If you are working on the different data sources and trying to load data to Netezza from multiple sources than you might encounter issues such as characters in integer column and that leads the loading to fail. Hence, it is very important to perform Netezza integer value check when you are not sure about source data types. Why should check for bad Records? If you are working on the data warehouse and multiple sources, sometimes you load in data sourcing from character data into a numeric or integer field in…

Continue ReadingNetezza Integer Value Check
Comments Off on Netezza Integer Value Check
March 4, 2017
Netezza

Netezza Mako Features – Latest Netezza powered DWH Appliance

IBM Netezza Mako server is latest addition to the IBM PureData System for Analytics system powered by Netezza technology. Netezza Mako features includes Fast, Scalable, Smart, Simple and completely integrated data warehouse appliances. Netezza Mako Features - Latest Netezza powered DWH Appliance IBM PureData System for Analytics system powered by Netezza technology is designed for running complex analytics solutions on very large data volumes of data sets with faster execution times compared to its entire predecessor. Check out: Key Features of Netezza Appliances Netezza Striper Architecture: N2001 Technical Specification Netezza…

Continue ReadingNetezza Mako Features – Latest Netezza powered DWH Appliance
Comments Off on Netezza Mako Features – Latest Netezza powered DWH Appliance
March 2, 2017
Netezza

Netezza Mako Architecture: N3001 Technical Specification

IBM PureData System for Analytics N3001 or Netezza Mako Architecture is the next generation of the PureDataTM System for Analytics family of appliances that is powered by Netezza technology. The Netezza Mako architecture integrates database, server (High available RH Linux Servers), storage (disks), and advanced analytic capabilities into a single, easy-to-manage system. The N3001 series servers includes hardware with an accelerated massively parallel-processing design that is specifically optimized for running complex analytics on large data volumes at very high speeds. The Netezza Mako server includes the design that is specifically…

Continue ReadingNetezza Mako Architecture: N3001 Technical Specification
Comments Off on Netezza Mako Architecture: N3001 Technical Specification
February 21, 2017
Netezza

Netezza Striper Architecture: N2001 Technical Specification

IBM PureData System for Analytics N2001 or Netezza Striper is a purpose-built, standards-based data warehouse and analytic appliance. The Netezza striper architecture integrates database, server (High available RH Linux Servers), storage (disks), and advanced analytic capabilities into a single, easy-to-manage system. The Netezza Striper includes the design that is specifically designed for running complex analytics on large volumes of data sets (petabytes of data) at high speed. Netezza Striper Architecture The IBM PureData System for Analytics N2001 series data warehouse appliances increases the storage capacity and performance of the Netezza TwinFin models. Within…

Continue ReadingNetezza Striper Architecture: N2001 Technical Specification
Comments Off on Netezza Striper Architecture: N2001 Technical Specification
February 21, 2017