To_Integer - Convert a String To Integer in Informatica

The TO_INTEGER function converts any value (except binary) to an integer by rounding the decimal portion of a value.

Syntax
TO_INTEGER( value )

Example : Converting a Decimal to Integer Value
TO_INTEGER( AVERAGE  )
AVERAGE     RETURN VALUE
'85.5784'         86
'50.2'             50