You are not logged in.
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?
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.