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
Money Equivalent datatype in Netezza
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: