Transformation Language Functions
This section describes new features of transformation language functions in version 10.0.
Informatica Functions
This section describes new features of Informatica functions.
CaseFlag
Effective in version 10.0, the CaseFlag option does not support NULL values for the following functions: GREATEST, LEAST, IN, and INDEXOF.
Previously, the CaseFlag option supported NULL values.
For more information, see the "Functions" chapter in the Informatica 10.0 Developer Transformation Language Reference.
TO_DECIMAL38 Function
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.