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 ......