The Emp table contains the salary and commission in USD, in the target the com and sal will converted to a given currency prefix ex: Rs.

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        Rs.800                20    

7499 ALLEN     SALESMAN          7698 20-FEB-81       RS.1600               30     

                   

1. Drag the source and connect it to expression transformation
   
2. In expression make a output port sal1 and make sal as input port only.
   
3.  In sal1 write the condition as like bellow
   
4.  Then send it to target.