Hi.
I'm having a problem using Oracle Connector.
This is my job: Seq.file ---> Trasformer ----> Oracle Connector
The input field UNIT_PRICE is defined in the following way in the input file:
SQL type = Double
Length = 38
Display = 40 (38 and 40 are as imported)
In the trasformer output link there is the same definition for the corresponding output field.
In the seq. file is present the value UNIT_PRICE = 0.333329.
Using Oracle Connector the table this value is loaded as 0.333328999999999 instead of 0.333329, why ?
Using the OCI Stage the value is loaded fine, as 0.333329.
The first thing I notice is that in Oracle Connector Stage tab 'Column' the 'Display' field property is not present.
I suppose that an implicit conversion changes the value.
Could someone help me, please?
Many thanks,
Andrea
Oracle Connector conversion problem
Moderators: chulett, rschirm, roy
Sorry, too much PX on the brain. If you work with FLOAT you'll see all kinds of issues like this so... don't. Probably won't help but do the move from a string field to a decimal with the proper scale in the transformer and then map that decimal to the NUMBER in Oracle. If that still doesn't work but is not an issue with OCI then I'd think you'd need to contact support about the Oracle Connector issue and see what they suggest.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I was supposed last last post then samechulett wrote:Sorry, too much PX on the brain.
Read as Varchar and write as decimal works fine, but also read as double works fine.chulett wrote: If you work with FLOAT you'll see all kinds of issues like this so... don't. Probably won't help but do the move from a string field to a decimal with the proper scale in the transformer and then map that decimal to the NUMBER in Oracle.
So I suppose the important thing is write as decimal
Many thanks.
Andrea