I have a job that uses a file to provision Oracle tables into Netezza tables. Below is the simple job set-up:
Code: Select all
Oracle Connector ---> Netezza Connector
One of the users is complaining about a data type conversion. It seems if the Oracle data type is NUMERIC(*,0), it converts into DOUBLE in Netezza. The user would like it to be INTEGER.
Is there any way I can specify this conversion without changing my current job layout?
Thanks in advance.