Oracle Enterprise stage decimal conv Warning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vsusmita
Participant
Posts: 4
Joined: Thu Aug 04, 2005 7:21 am

Oracle Enterprise stage decimal conv Warning

Post 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
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Re: Oracle Enterprise stage decimal conv Warning

Post 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.

:)
Post Reply