Pages

Sunday, March 17, 2013

Reading a source file with salary prefix $ , in the target the Sal column must store in number . Source


Source:
EMPNO ENAME      JOB              MGR HIREDATE         SAL            DEPTNO
7369 SMITH            CLERK           7902 17-DEC-80        $800                20             
7499 ALLEN      SALESMAN        7698 20-FEB-81         $1600               30             
Target
EMPNO ENAME      JOB              MGR HIREDATE         SAL            DEPTNO
7369 SMITH            CLERK           7902 17-DEC-80        800                20             
7499 ALLEN      SALESMAN        7698 20-FEB-81         1600               30     
  1. Drag the source to mapping area and connect each port to an expression transformation.
  2. In expression transformation add a new col sal1 and make it as out put and sal as in put  only as shown in picture.
    expression
  3. In expression write the condition like this.
  4.  connect the required port to target.

No comments:

Post a Comment