reading decimal values from oracle E STAGE
Posted: Thu Apr 03, 2008 1:01 am
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
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
but here i am getting warnings in log file like this
meta data definition is like this column"floating point decimal is not fully supported; adjusting the scale."
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