Sunday, March 17, 2013

How to seperate Middle Name From Ename

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.

No comments:

Post a Comment