You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Excel data problem
#1 2012-04-27 12:18:02
- mfuzaimi
- Member
- Registered: 2011-10-05
- Posts: 39
Excel data problem
Hi,
I am doing mapping 1 to 1 from excel source to new table..
the only problem is the data is diffrent between the source and table
for example: 1 row from source is valued 7554586.68 but in target new table the value change to 7554586.5
I am not sure wether this is a datatype problem which make the etl rounding the value.
Does anyone had this experience before?
Regards,
Fuzaimi
Offline
#2 2012-04-27 17:19:44
Re: Excel data problem
Fuzaimi,
What data types are specified for the input and output? Have you tried specifying the type as a BigDecimal? Although BigDecimal can be more cumbersome for performing calculations, it does not lose precision.
Thanks,
Ben
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Excel data problem