Geting warning's in decimal conversion

naidu · Post by **naidu** » Mon Oct 26, 2009 3:09 pm

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. "

chulett · Post by **chulett** » Mon Oct 26, 2009 3:13 pm

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.

naidu · Post by **naidu** » Mon Oct 26, 2009 3:33 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 26, 2009 5:35 pm

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.

chulett · Post by **chulett** » Mon Oct 26, 2009 5:42 pm

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.

naidu · Post by **naidu** » Tue Oct 27, 2009 8:03 am

So there is nuthing i can do to avoid these warnings

chulett · Post by **chulett** » Tue Oct 27, 2009 8:23 am

If your source is really a Decimal[38,10] and your target is Decimal[7,1] then no, it will always alert you to that possibility. What are the actual range of values in the source field?

HariK · Post by **HariK** » Wed Oct 28, 2009 7:19 am

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.

naidu · Post by **naidu** » Wed Oct 28, 2009 8:59 am

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 i am suppressing all the warning messages.

chulett · Post by **chulett** » Wed Oct 28, 2009 9:20 am

Not necessarily the wisest choice. Any chance you could answer my last question?

naidu · Post by **naidu** » Wed Oct 28, 2009 9:28 am

chulett wrote:Not necessarily the wisest choice. Any chance you could answer my last question? ...

Yeah Craig my source Decimal[38,1] and your target is Decimal[7,1]

chulett · Post by **chulett** » Wed Oct 28, 2009 9:59 am

That wasn't the question.