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
Warning : Problem in adjusting floating point
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try something like
Code: Select all
SELECT CAST (MAX(ADDR_KEY) AS NUMBER(11)) ADDR_KEY ...
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Warning : Problem in adjusting floating point
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
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
Archana
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 9
- Joined: Tue Jul 26, 2005 11:12 pm
- Location: Bangalore
Re: Warning : Problem in adjusting floating point
Hi
Use the DRS stage instead of the Oracle Enterprise stage. this will solve your problem.
Kiran
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
Regards,
Kiran
Kiran