When you take a source as Flatfile and it consists one of the feild as NAME .The following below table is the source table data::

NAME

Ravi

Ramesh

Swathi

Jack

In the above table you can clearly see the Name values are not aligned properly and to align the data into equally .We have to use TRIM concept .Now in our mapping we are loading above data into target table .But in target table it appears like as shown below

NAME

Ravi

Ramesh

Swathi

Jack

The above can be acheived by using the LTRIM( ) function in expression editor.This is declared in Expression transformation output port.

The function appears like this LTRIM(NAME)