Warning : Problem in adjusting floating point

Archana · Post by **Archana** » Thu Oct 05, 2006 12:38 am

Hi ,

We have got a column(addr_key) in the oracle table which has metadata like Number(11).
In the datastage job , we have a query like

SELECT MAX(ADDR_KEY) ADDR_KEY
, 'ADDR_DIM' TABLE_NAME
FROM ADDR_DIM

While running the job we are getting following warning.

oraAddrDimsel: Column ADDR_KEY floating point decimal is not fully supported; adjusting the scale.

Please, let me know what needs to be to remove such warnings .

Thanks in Advance
Archana

ray.wurlod · Post by **ray.wurlod** » Thu Oct 05, 2006 12:57 am

Try something like

Code: Select all

SELECT CAST (MAX(ADDR_KEY) AS NUMBER(11)) ADDR_KEY ...

Archana · Post by **Archana** » Thu Oct 05, 2006 1:19 am

Hi,

Thanks a lot for the response.
I tried the query you sent . But still I am getting the same warning.
Could you please suggest me ssome more options??

Thanks
Archana

keshav0307 · Post by **keshav0307** » Thu Oct 05, 2006 3:22 am

use

Code:
SELECT CAST (MAX(ADDR_KEY) AS CHAR(11)) ADDR_KEY from ...

then convert it into number

kumar_s · Post by **kumar_s** » Thu Oct 05, 2006 6:41 am

What is the datatype for ADDR_KEY in datastage?

goosarikiran · Post by **goosarikiran** » Thu Oct 05, 2006 9:28 am

Hi

Use the DRS stage instead of the Oracle Enterprise stage. this will solve your problem.

Kiran

Archana wrote:Hi ,

We have got a column(addr_key) in the oracle table which has metadata like Number(11).
In the datastage job , we have a query like

SELECT MAX(ADDR_KEY) ADDR_KEY
, 'ADDR_DIM' TABLE_NAME
FROM ADDR_DIM

While running the job we are getting following warning.

oraAddrDimsel: Column ADDR_KEY floating point decimal is not fully supported; adjusting the scale.

Please, let me know what needs to be to remove such warnings .

Thanks in Advance
Archana

DSXchange