Page 1 of 1

Oracle Enterprise stage decimal conv Warning

Posted: Wed Jun 07, 2006 11:29 am
by vsusmita
Hi,

I am trying to extract data from oracle table unis oracle enterprice editionstare it has decimal column
RATE_REQ Number

in datastage i have spcified metadata as float 10,2 ,
i am getting following warning..
Oracle_Enterprise_1: Column RATE_REQ floating point decimal is not fully supported; adjusting the scale

i even tried different formats in datastage metadata like smallint,bigint,
deciam 38,2

still i am gettign same wraning,,

is there any way to eliminate this warning..

thanks in advance
susmita

Re: Oracle Enterprise stage decimal conv Warning

Posted: Wed Jun 07, 2006 1:05 pm
by sud
vsusmita wrote: Oracle_Enterprise_1: Column RATE_REQ floating point decimal is not fully supported; adjusting the scale
The message itself is the answer. Floating point decimal is not fully supported and datastage has to report that. If you do not want the warning you have to do message handling and demote this to a Info.

:)