Tags » Netezza

Former Netezza Team Reunites And Lands $8M To Solve Today's Big Data Problem

In 2000, some companies had big data problems before the concept we know today even existed. Back in those days, these organizations used a concept called the data warehouse to deal with large amounts of data, and a company called… 571 more words


Records are rejected while Loading into Netezza Table Using Informatica ?

loading special characters in Netezza? (how far this statement is correct)

I have seen in many communities developers facing issue while loading (into Netezza) for few character Using Informatica. 807 more words


Changing the Game for Data Warehouse Appliances

By Rich Hughes, 

“The more things change, the more they stay the same” is a French adage observing that the status quo has a way of retaining prominence, even in turbulent times.  684 more words

Big Data

How to upload Netezza NZSQL and NZLOAD output to a file.


Can I export the SQL query results from Netezza? 


Lets see how to do this

nzsql -u USER001 -pw pass1 -db PGBDB201  -host myhost.com -c “SELECT * FROM COMPLE.PROD_DIM” > /infa001/Src/PROD.txt… 148 more words


netezza string aggregation

Sting aggregation in Netezza


Input data 


101 Kumar

101 Swami


102 John

102 D


103 David

103 R


104 jean morgan


required Out put 


101 Kumar Swami… 146 more words


String Functions in Netezza

Netezza Array Functions and their advantages.


How to replace a character in the string in Netezza.


Ex:- SELECT array_combine(Array_split(‘1NETEZZA’,‘1’),‘IBM_’);

The above query replace 1 with ‘IBM_’ 215 more words