Effective in version 10.0, you can use the TO_DECIMAL38 function to convert a string or numeric value to a decimal value. The function returns a decimal value of precision and scale between 0 and 38, inclusive.

For more information, see the

Informatica 10.0 Transformation Language Reference

.