What are the types of lookup caches?
Answer Posted / swetha
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 he lookup table, yoU can configure the
lookup transformation to rebuild the lookup cache.
Static cache: U can configure a static or readonly 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
prosesses 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 inerts data to the target table.
shared cache: yoU can share the lookup cache between
multiple transactions.yoU can share unnamed cache between
transformations inthe same maping.
Is This Answer Correct ? | 63 Yes | 4 No |
Post New Answer View All Answers
Explain the types of transformations?
How to update or delete the rows in a target, which do not have key fields?
Which transformation is needed while using the Cobol sources as source definitions?
Explain pushdown optimization $pushdownconfig parameter - informatica
where to store informatica rejected data? How to extract the informatica rejected data?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is meant by active and passive transformation?
How to load the data from people soft hrm to people soft erm using informatica?
What is the use of code page?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is transformation?
What is a repository? And how to add it in an informatica client?
In which transformation you cannot drag ports into it?
What do you mean by blocking transformation?
What is informatica worklet?