Question

Why we use enable high precision in session properties?

Answer 1

when a session runs without high precision the integration service convert decimal to double

Answer 2

Informatica help: “To ensureprecision of up to 28 digits, usethe Decimal datatype and enable high precision in the session properties. ... If the session does not run with high precision, the Integration Service converts the decimal value to Numeric and passes 4001203030 to the next transformation.