Saturday 12 July 2014

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. )
  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. Click on ok
  8. Drag and drop deptno,dname,loc from source qualifier to lookup transformation
  9. Double click on Lookup click on condition tab and select condition as shown
  10. Observer policy property
  11. Click on ok
  12. connect corresponding columns from lookup to target
  13. save it
  14. create workflow and session
  15. run it observe run properties
  16. Source input records to lookup are 4 and output records are 21 hence lookup acting as a Active transformation

No comments:

Post a Comment