Several days ago when I ran a PowerCenter session, I encountered an issue of populating column value of money data type from one Microsoft SQL Server table to another. For example, the original source value is 1234.1250, but after I loaded it to another table, it became 1234.1136.
The Future of Big Data
With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.
In Informatica, the column data type is set to money in source and target table definition. And we set it to decimal (19, 4) in middle transformations because there is no money data type in transformation.
To resolve this issue, we could enable the high precision property in the session properties. This ensures that the data type is processed to a precision of 28.
You can do the following:
- Go to Properties tab of session and scroll down to Performance area.
- In the Performance area, select the box against the option Enable high precision.