What are the types of lookup caches?
Persistent cache: you can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache.
Recache from database: If the persistent cache is not synchronized with the lookup table, you can configure the lookup transformation to rebuild the lookup cache.
Static cache: you can configure a static or read-only cache for only lookup table. By default informatica server creates a static cache. It caches the lookup table and lookup values in the cache for each row that comes into the transformation. when the lookup condition is true,the informatica server does not update the cache while it processes the lookup transformation.
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.
Shared cache: you can share the lookup cache between multiple transactions you can share unnamed cache between transformations in the same mapping.
No comments:
Post a Comment