reading decimal values from oracle E STAGE

[chvenkat.v]

I have a scenario where i am extracting data from Oracle database and manking tranformations on that data. So my first stage will be oracle enterprise stage to pull data and from there the job flows. My concern here is if i put the nullable filed of a column to 'YES' in the stage.
but here i am getting warnings in log file like this

"floating point decimal is not fully supported; adjusting the scale."

meta data definition is like this column
IN_C_CNT -Decimal -Length-12 - Scale-0
in the sql query : like this select
COUNT(CASE WHEN CALL_DIRE=0 THEN 1 END) IN_C_CNT from ....

pls tell i need to set any envir. variable for this.

thnks
venkat

[ArndW]

Venkat - this particular question has been asked and answered to many times in the past. Please use the "search" function to find the responses.