Hi,
Job Details: Source and Targets are Oracle tables
In source table some of the columns are defined as NUMBER and I have taken these columns metadata as Decimal[38] in Source stage. When I run this job I am getting below warning for all these types of columns.
oraStore: When checking operator: When binding output interface field "STORE_AGE_CLS_NUM" to field "STORE_AGE_CLS_NUM": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,0]": Possible precision limitation.
oraStore,0: Column STORE_AGE_CLS_NUM floating point decimal is not fully supported; adjusting the scale.
I have tried with change in the metadata as Decimal(38,10), but still I am getting the same warnings. Actual data in source table is numbers Ex: 102, 1342 etc...
And the above warnings are comming when query is pulling the data from source tables in Source stage only. Even I am not able to use some transformation functions also here.
Any solution for above problem.Please help on this.
Thanks.
Decimal precision warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's an alert. DataStage is warning you that, in going from a scale of 10 to a scale of 0 you are likely to lose some information. It is also alerting you to the fact that it (DataStage) does not fully support numeric floating point decimal, and that therefore it is adjusting the scale so that the number can be managed.
Try changing your source data type to int32.
Try changing your source data type to int32.
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.
-
- Participant
- Posts: 13
- Joined: Fri Jul 15, 2005 12:01 am
Re: Decimal precision warning
Hi
fields "STORE_AGE_CLS_NUM" and "STORE_AGE_CLS_NUM" read as Varchar from source and cover to decimal using StringToDecimal.
fields "STORE_AGE_CLS_NUM" and "STORE_AGE_CLS_NUM" read as Varchar from source and cover to decimal using StringToDecimal.
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
Re: Decimal precision warning
Thanks for your response Satyanarayana.satyanarayana wrote:Hi
fields "STORE_AGE_CLS_NUM" and "STORE_AGE_CLS_NUM" read as Varchar from source and cover to decimal using StringToDecimal.
But I can not use the StringToDecimal function here, because the warning is comming at source stage(While reading the data from source table by using user defined query). How can I read as Varchar and convert into Decimal. Can you explain in more clear.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: