Tags » Netezza

invalid precision or scale value (informatica with neetzza as target)

This error may cause when your string column length is 64K. try to reduce it to 63999

and then try to load the data.


Netezza - Points to remember

With CTAS(Create table as select) if the distribution key is not explicitly specified,

  • If source table has defined distribution key, new table will use same set of attributes for distribution.
  • 214 more words
Groom Table

Netezza: Object & admin privileges

A user/group can have an object or admin 0r both privileges granted to it. Below queries will help you to find out those details:

(1) Object privileges granted to an user/group… 19 more words


UDX (User Defined Extensions)

Introduction to UDX:

Traditionally we support three in-built functions to perform basic in-house database functionalities. i.e. Scalar functions, Aggregate functions, Table functions.

Additionally, Netezza provides a user to implement a freestanding, executable data-processing program that runs “out of process,” and register it in a database. 295 more words

Information Management

Netezza: dbos.log (vs) pg.log

Both – dbos.log and pg.log – these logs are very useful in understanding SQL statements that are hitting Netezza database system.

dbos.log: Records information about SQL plans (/nz/kit/log/dbos/dbos.log) 235 more words


Netezza: Multiple history databases

(Q) Can we have multiple history databases created?

An history database captures information about user activity such as