warning on insert decimal with oracle stage load append mode
Posted: Fri Jan 23, 2009 11:15 am
Hi all,
I have a target oracle table with a few columns declared as NUMBER. I'm getting a warning in the execution of the job that inserts data to this table. the warning is " When checking operator: Column ID_CONTRAT floating point decimal not fully supported. Adjusting scale." the column ID_CONTRAT is declared as number in oracle table and the metadata in datastage is decimal(38,10).
The job does what i need it to do but with warnings for each column declared as number.
I have tried to change the types of my columns to Numeric, Integer, and Bigint but it doesn't change the warning, instead of that it adds more warnings concerning the implicit conversion.
PS: when I change the target to a dataset, the job run perfectly well without warnings.
I'll be very grateful if anybody can help
I have a target oracle table with a few columns declared as NUMBER. I'm getting a warning in the execution of the job that inserts data to this table. the warning is " When checking operator: Column ID_CONTRAT floating point decimal not fully supported. Adjusting scale." the column ID_CONTRAT is declared as number in oracle table and the metadata in datastage is decimal(38,10).
The job does what i need it to do but with warnings for each column declared as number.
I have tried to change the types of my columns to Numeric, Integer, and Bigint but it doesn't change the warning, instead of that it adds more warnings concerning the implicit conversion.
PS: when I change the target to a dataset, the job run perfectly well without warnings.
I'll be very grateful if anybody can help