Tags » Netezza

After a long time ...

It has been almost a year since my last post. So many things have happened these days. My laptop OS (Ubuntu) got corrupted (so many things lost). 159 more words

Date validation in Netezza

In Netezza how to validate the source date. Lets say i have to check if the source date is coming in the formart ‘YYYY-MM-DD’ or not. 160 more words


query databases in netezza

select distinct database from  _V_OBJ_RELATION_XDB where owner='’


Working with nzload (To Load file into Netezza)

Lets create a Profile file to pass all the values to the script.

Profile File:- (deceleration)



SRC_PATH=”/e/srcfiles/GBT” 478 more words


Identification of Right Netezza Data Management

In today’s information driven world, just about every person is well aware about the significance of the right management of data. However, merely being conscious about the advantages and importance of… 480 more words

Convert Julian date to calendar date in Netezza

Use the Below to convert julian date to calendar date in Netezza

TO_DATE(substr(Your_date_column,1,4) || ‘0101’,‘YYyyMMDD’ )+TO_NUMBER(SUBSTR(Your_date_column,5,3),‘999’)-1.


Convert Calendar Date to Julian date in Informatica. 22 more words


Netezza MDM – Why is it Important for Businesses?

Master data management systems have become mandatory for the success of all business over the past couple of years since they are so useful. Also known as MDMs, these are used in order to keep master data secure at all times. 263 more words