Tags » Netezza

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

Netezza

query databases in netezza

select distinct database from  _V_OBJ_RELATION_XDB where owner='’

Netezza

Working with nzload (To Load file into Netezza)

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

Profile File:- (deceleration)

PATH_LIB_ODBC=”$PATH:/e/infa91/Netezza/bin”
LIB_PATH=”$LIBPATH:/e/infa91/Netezza/lib64″
NZ_ODBC_INI_PATH=”/e/infa/ODBC/ODBC6.1″

HOME_PATH=”/e/infa91/Netezza/bin”

PROFILE_DIR=”/e/deployment/scripts/GBT/GBTSCR”
QUER_PATH=”/e/deployment/scripts/GBT/GBTSCR”
SRC_PATH=”/e/srcfiles/GBT” 478 more words

Netezza

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.

Informatica:-

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

Netezza

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

The Necessity for PureData Master Data Management

For all they are worth, master data management systems like PureData  are also the major reason behind the expansion as well as increased profitability of all businesses. 179 more words