Page 1 of 1
ORACLE Data conversion warning
Posted: Fri May 11, 2007 1:12 pm
by UPS
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?
Posted: Fri May 11, 2007 1:45 pm
by DSguru2B
What is the length and scale of the double field? It might be more than the target and hence the warning.
Posted: Fri May 11, 2007 4:05 pm
by ray.wurlod
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.