BICC columns with numeric datatype fetching incorrect decimal values.

Summary:

We observed that an issue with BICC extract for columns with numeric datatypes. We noticed that columns with numeric datatype, for decimal values, its fetching incorrect decimal values.

Eg : ERP OM Amount = 10.123

BICC Extract value for Amount = 10.123000000000001

As a fix, we casted one of the numeric field as string and tested the same by running the BICC job and received the expected results.

However, as per BICC documentation -

Extract as String is recommended only when there is a requirement to maintain precision for numeric values with more than 15 digits.

How can numeric values with decimal values be handled without casting it as string, since, as per documentation, it's not the preferred method.