Sunday, March 17, 2013

How to seperate first and last name

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.

No comments:

Post a Comment