Q21: Reading a source file with salary prefix $ , in the target the Sal column must store in number .
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.