Suppose in e_name column is like this

empno            ename

1                   Sudhansu Sekher Dash

2                   Amiya Prasad Mishra

In target we have to send middle name like this

empno      ename

1              Sekher

2              Prasad

These are the steps for achieving this

  1. Drag the source and connect to an expression transformation
  2. In Expression create two ports one is name1(as variable port) and Middle_Name (o/p port)
  3. In Name1 write the condition like this
  4. In Middle_Name write the condition like this
  5. Then send to target.