Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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