Oracle Connector conversion problem
Posted: Wed Sep 03, 2014 7:25 am
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
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