LOOKUP IN ODI 11G

Step 1: Creating target table

1. open SQL DEVELOPER and execute below script
2. 
3. Reverse Engineer LKP_EMP_DNAME_LOC table into RRITEC_MODEL_TARGET

Step 2: Creating INTERFACE

1. Create a INTERFACE with the name of m_LOOKUP_DNAME_LOC
2. DRAG AND DROP SOURCE emp AND TARGET LKP_EMP_DNAME_LOC
3. Click on the lookup button
4. 
5. select driving and lookup tables
6. 
7. select deptno column → click on join
8. 
9. Click on finish
10. click on flow tab → select target → select flow_control =False
11. save → run → observe output
12.