Dynamic Cache in Informatica Lookup Transformation

As we saw in our previous informatica tutorial , that  look transformation cache need to be enabled to boost the performance of Lookup transformation( by avoiding lookup in the lookup source again and again)

Now if Look up source is getting changed , then we  need to also refresh lookup cache. Dynamic cache in lookup Transformation solves our purpose  :).

Dynamic cache:

If you want to cache the target table and insert new rows into cache and the target,you can create a look up transformation to use dynamic cache.The informatica server dynamically inserts data to the target table. 

 

1. You cannot share the cache between a dynamic Lookup transformation and static Lookup transformation in the same target load order group.
2. You can create a dynamic lookup cache from a relational table, flat file, or source qualifier transformation.
3. The Lookup transformation must be a connected transformation.
4. Use a persistent or a non-persistent cache.
5. If the dynamic cache is not persistent, the Integration Service always rebuilds the cache from the database, even if you do not enable Re-cache from Lookup Source.
6. When you synchronize dynamic cache files with a lookup source table, the Lookup transformation inserts rows into the lookup source table and the dynamic lookup cache. If the source row is an update row, the Lookup transformation updates the dynamic lookup cache only.
7. You can only create an equality lookup condition. You cannot look up a range of data in dynamic cache.