Geting warning's in decimal conversion
Moderators: chulett, rschirm, roy
Geting warning's in decimal conversion
Hi All
I am getting this warning can any one tell me how can i get rid of this warning
" ORCL_Src_OFOEtl: When checking operator: When binding output interface field "DESEASONALIZED_FCST" to field "DESEASONALIZED_FCST": Implicit conversion from source type "decimal[38,10]" to result type "decimal[7,1]": Possible range/precision limitation. "
I am getting this warning can any one tell me how can i get rid of this warning
" ORCL_Src_OFOEtl: When checking operator: When binding output interface field "DESEASONALIZED_FCST" to field "DESEASONALIZED_FCST": Implicit conversion from source type "decimal[38,10]" to result type "decimal[7,1]": Possible range/precision limitation. "
Thanks
Naidu
Naidu
You can't unless it is possible to change your incoming metadata to be no larger than your result, otherwise it will always warn you it may not fit. If you are sure it always will, you could demote the warning to informational, I suppose.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the reply i jus want to tell more details about the job the source is oracle stage and the targets are oracle and CFF stages and the job is migrated from 7.5v to 8.1v and it is running fine without any warnings in 7.5v and why does it shows warning messages in 8.1 could you please help me out in this.
Thanks
Naidu
Naidu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because checking is more stringent in version 8. This is an alert rather than a warning. You are being informed that you are potentially trying to squeeze a large value (with 38 significant digits) into a smaller receptacle (only having seven significant digits), that there are some values (those with eight or more significant digits) for which this operation is guaranteed to fail.
You can demote the message to informational using a message handler if you are totally confident that the source data will never contain more than eight significant digits.
You can demote the message to informational using a message handler if you are totally confident that the source data will never contain more than eight significant digits.
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.
In other words, 7.5 should really have given you that same alert but didn't, that's now been corrected in 8.1. With any upgrade there's the chance you'll no longer to be able to get away with things you really shouldn't have gotten away with in the first place.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks i am suppressing all the warning messages.HariK wrote:You can check if the particular warning is downgraded to information or suppressed from log on 7.5 V. If it is the case then you can do the same in 8V.
The mentioned activity is done on director. not sure whether it will get migrated when upgraded from one to other.
Thanks
Naidu
Naidu