One Star

loss of precision with float from oracle

Hi,
I create a small table in Oracle:
create table jmtest ( f1 float )
insert into jmtest values(1487580.72);
and select * from jmtest:
F1
1487580,72
so, a very small job in Talend with tOracleInput and a csv for output
float in input and java float in output (type are automaticly produced by Talend)
and unfortunaly:
$ cat /tmp/jmtest.csv
1487580.8
If I insert a new value:
insert into jmtest values (9757889.86)
select * from jmtest
F1
1487580,72
9757889,86
and the ersult is
jmax-laptop% cat /tmp/jmtest.csv
1487580.8
9757890.0
so, how can I preserve my values ?
thanks for your tips
1 REPLY
One Star

Re: loss of precision with float from oracle

idem with output in tLogRow to exclude the tFileOutputDelimited component
it is the reading of the oracle database which lost precision