Monday 14 July 2014

Persistent Cache

  1. Open existing Mapping m_connected_lkp_deptname
  2. Double Click on lookup → Go to properties tab → Enable Lookup cache Persistent
  3. Save it → Go to corresponding workflow → right click on session → click on refresh mapping
  4. Save it
  5. Notice that in cache default folder is empty
    1. Note : the default path is C:\Informatica\9.1.0\server\infa_shared\Cache
  6. Run the workflow
  7. Notice that target table loaded with data and also cache created
  8. To prove from next run onwards it will read from cache → change some source data (in my case i changed dname sales123456 to sales) → commit
  9. enable Truncate target table option
  10. Run the workflow → notice that the changed data of source not loaded in to target as it read from cache
  11. to read from source by skipping cache  → enable recache from lookup cache
  12. save it → run workflow
  13. observe output ,the changed data of source loaded  into target




No comments:

Post a Comment