Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Trim in Informatica

  1. Forget Code
  2. Informatica
  3. Trim
Trim Function is not directly available Informatica.

However the same functionality can be achieved by LTRIM and RTRIM.

LTRIM(RTRIM(ColumnName))

In the above example LTRIM and RTRIM is used with no arguments, so it removes leading and trailing blank spaces.