- Open existing Mapping m_connected_lkp_deptname
- Double Click on lookup → Go to properties tab → Enable Lookup cache Persistent
- Save it → Go to corresponding workflow → right click on session → click on refresh mapping
- Save it
- Notice that in cache default folder is empty
- Note : the default path is C:\Informatica\9.1.0\server\infa_shared\Cache
- Run the workflow
- Notice that target table loaded with data and also cache created
- 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
- enable Truncate target table option
- Run the workflow → notice that the changed data of source not loaded in to target as it read from cache
- to read from source by skipping cache → enable recache from lookup cache
- save it → run workflow
- observe output ,the changed data of source loaded into target
Monday, 14 July 2014
Persistent Cache
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment