Money Equivalent datatype in Netezza

[nansekar]

Hi Team

We have a Job to extract data from SQLSERVER to Netezza.

Source : ODBC stage
Target : Netezza Connector Stage
Options specified : RCP Enabled

It is a Direct dump, select * from table name and insert into Netezza.

Issues : The SQL datatypes and Netezza dataype doesnt match hence the values are populated as Zero.

SQLServer datatype : ABC_AMT [MONEY]
Netezza datatype : ABC_AMT NUMERIC(15,2)

SQLServer datatype : ABC_CNT [Real]
Netezza datatype : ABC_AMT INTEGER

So all the amt and cnt cols in Netezza table are being populated as Zero.

Kindly let me know the SQl Real and Money Equivalent datatypes in Netezza

Thank you

[ray.wurlod]

Try NUMERIC(19,4) for mapping MONEY, and REAL or FLOAT(6) for mapping REAL.

[nansekar]

Hi Ray

Thank you for the Soln,
for Money : Numeric(19,4) or 15,2 worked, but for the REAL : Real in Netezza did not work ( the counts were increased while loading into Netezza)

So we had Integer type for Real, and Typecasted it.