ODI 11G INTERFACE FOR TOTALSAL AND TAX

ODI 11G INTERFACE FOR TOTALSAL AND TAX

Step 1: Reverse engineer source into source model

1. right click on scott source model and reverse engineer emp table
2. 

Step 2: Reverse engineer Target into Target model

1. Create table in target database
   CREATE TABLE TGT_EMP

 (

   EMPNO    NUMBER,

    ENAME    VARCHAR2(30),

   SAL      NUMBER ,

    COMM     NUMBER,

   TOTALSAL NUMBER,

   TAX      NUMBER,

    DEPTNO   NUMBER

  )

1. Right click on TDBU Target model and reverse engineer tgt_emp table
2. 

Step 3: Create interface

1. Expand projects → Right click on interface → new interface → name it as m_TOTALSAL_TAX
2. 
3. Go to mapping tab
4. drag and drop source EMP and target TGT_EMP into respective areas → click on ok on auto mapping window
5. 
6. Go to totalsal column → in properties pane develop below expression
7. 
8. Go to Tax column → in properties pane develop below expression
9. 
10. select flow tab  → then select target → select IKM SQL CONTROL APPEND
11. select flow option as FALSE
12. 
13. save → run → observe output of TGT_EMP table
14.