Active Lookup

Step1: Create a mapping

1. Use source as dept
2. Create a table as target and import into informatica
1. CREATE TABLE tgt_Active_lookup(
2.    DEPTNO number,
3.    DNAME  varchar2(30),
4.    ENAME  varchar2(30),
5.    SAL    number,
6.    LOC    varchar2(30)
7. )
8. 
3. Import into informatica as target
4. Create a mapping with the name of m_Active_lookup
5. Drag and drop source dept and target tgt_active_lookup
6. click on lookup tranformation and select emp as lookup table and enable Return all values on Multiple match
7. 
8. Click on ok
9. Drag and drop deptno,dname,loc from source qualifier to lookup transformation
10. Double click on Lookup click on condition tab and select condition as shown
11. 
12. Observer policy property
13. 
14. Click on ok
15. connect corresponding columns from lookup to target
16. 
17. save it
18. create workflow and session
19. run it observe run properties
20. 
21. Source input records to lookup are 4 and output records are 21 hence lookup acting as a Active transformation