Issue reading Oracle NUMBER datatype column
Posted: Thu Dec 27, 2007 4:34 am
I have a simple parallel job which is reading an Oracle table and via a transformer stage to load a Netezza table using the Netezza enterprise.
The issue I'm having is that the job is raising warnings when Oracle stage is reading a NUMBER datatype column. The job is raising the following warning :-
OSO_OPPORTUNITY_DETAILS: Column LEAD_ID floating point decimal is not fully supported; adjusting the scale.
I've tried to re import the meta data, and also tried to change the datatype once it has been imported, but am unable to get rid of the warning.
When I import the column, the Datastage type is decimal(38,10).
I don't believe the target table is causing a problem, but for reference the target columns is specified has numeric(18,0).
This warning appears in several jobs with the same issue.
Any suggestions would be greatly appreciated.
The issue I'm having is that the job is raising warnings when Oracle stage is reading a NUMBER datatype column. The job is raising the following warning :-
OSO_OPPORTUNITY_DETAILS: Column LEAD_ID floating point decimal is not fully supported; adjusting the scale.
I've tried to re import the meta data, and also tried to change the datatype once it has been imported, but am unable to get rid of the warning.
When I import the column, the Datastage type is decimal(38,10).
I don't believe the target table is causing a problem, but for reference the target columns is specified has numeric(18,0).
This warning appears in several jobs with the same issue.
Any suggestions would be greatly appreciated.