ORACLE Data conversion warning

UPS · Post by **UPS** » Fri May 11, 2007 1:12 pm

We are getting the following warning message during our load:

"Implicit conversion from source type "dfloat" to result type "decimal[18,2]": Possible range/precision limitation."

The source definition is a 'double' and the target is NUMBER(18,2).

Any suggestions?

DSguru2B · Post by **DSguru2B** » Fri May 11, 2007 1:45 pm

What is the length and scale of the double field? It might be more than the target and hence the warning.

ray.wurlod · Post by **ray.wurlod** » Fri May 11, 2007 4:05 pm

This is a warning in the sense of an alert, rather than anything necessarily being wrong. Both "double" (SQL terminology) and "dfloat" (Orchestrate terminology) mean "double precision floating point number". These are huge beasts, and can certainly contain more than 18 significant digits.

You can demote the warning to informational with a local message handler, or you can add a data type conversion (Modify or Transformer stage) in your job. The Modify stage can have an additional Specification property containing the single token NOWARN to suppress generation of this kind of warning.