Suppose In Ename column there is first name and last name like this

empno   ename

1         Amit Rao

2         Chitra Dash

In target we have to separate ename column to firstnane and lastname like this

empno    firstname    Lastname

1             Amit           Rao

2             Chitra          Dash

Steps for solving this scenario

  1. Drag the source to mapping area and connect with an expression trans formation as shown bellow.
  2. In expression transformation create two output port one is f_name and other is l_name.
  3. In f_name write the condition like this
  4. In l_name write the condition like this

Then connect the target.

These are the basic steps for achieving this scenario