PowerCenter like decimal handling in Cloud Data Integration
Posted by: Informatica Success Portal
When mappings are converted from PC to IDMC, and they have decimal data type. The decimal fields yield different results in IDMC compared to PowerCenter. This listing should help you resolve the gap in behavior difference.
Overview
When PC mappings are converted to IDMC, the decimal/number Data type yields different results in IDMC while processing data with high precision. The difference in behavior originates from the difference in drivers. PC uses Oracle native driver while IDMC uses ODBC driver.
This resource kit contains a mapping and a mapplet with expressions that can used to generate PC type output.