Data Type Conversion - Ora to NZ - Using RCP

jweir · Post by **jweir** » Wed Dec 23, 2015 10:41 am

Hi all,

I have a job that uses a file to provision Oracle tables into Netezza tables. Below is the simple job set-up:

Oracle Connector --->  Netezza Connector

I am using RCP and selecting all data from the Oracle source table. In the Netezza connector, we are using the 'Replace' table function.

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.

kumar_s · Post by **kumar_s** » Wed Dec 23, 2015 3:02 pm

One options, that strikes my mind is to create the table prior to loading. And just 'Insert' the record.
While creating the table, convert those Numeric fields to integer.

jweir · Post by **jweir** » Mon Jan 04, 2016 8:30 pm

How could I convert those columns to Numeric if I do not know which ones I need to convert since I am using RCP?

ArndW · Post by **ArndW** » Tue Jan 05, 2016 9:12 am

Assuming you are doing a "SELECT * FROM {TableName}" in your source, could you perhaps create a view of the physical table with the appropriate CAST statement for those numeric columns and use the view instead? That would at least keep you from having to change the job.