Currency converter - Informatica mappings

Suppose that a source contains a column which holds the salary information prefixed with the currency code, for example  

EMPNO    ENAME          JOB                   MGR        HIREDATE              SAL                  DEPTNO 7369         SMITH            CLERK               7902       17-DEC-80          $300                  20              7499         ALLEN          SALESMAN         7698       20-FEB-81          £1600                30              7521         WARD         SALESMAN         7698       22-FEB-81          ¥8500                 30

In the target different currency will evaluate to a single currency value, for example covert all to Rupees.

1. First thing we should consider that there are different types of currency like pound, dollar, yen etc. So it’s a good idea to use mapping parameter or variable. Go to mapping => mapping parameter and variables then create three parameters (for this example) and set its initial value as bellow

 Then drag the source to mapping area and connect to an expression transformation.

 In expression create a output port as sal1 and make sal as input only as bellow.

in sal1 port write the condition as below

IIF(INSTR(SAL,'$')!=0,TO_INTEGER(SUBSTR(SAL,INSTR(SAL,'$')+1,LENGTH(SAL)-1))*$$DOLAR,

IIF(INSTR(SAL,'£')!=0,TO_INTEGER(SUBSTR(SAL,INSTR(SAL,'£')+1,LENGTH(SAL)-1))*$$POUND,

IIF(INSTR(SAL,'¥')!=0,TO_INTEGER(SUBSTR(SAL,INSTR(SAL,'¥')+1,LENGTH(SAL)-1))*$$YEN

)

)

·       $DOLAR, $$POUND, $$YEN these are mapping parameter. you can multiply price in rupee directly for example dollar price in rupees i.e 48.

Connect required output port from expression to target directly. And run the session.