What are the types of lookup caches?
- 10 Answers
- 65416 Views
- Accenture, IBM, Informatica, I also Faced
- E-Mail Answers
Answer Posted / sridhar
Persistent cache: U 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,U 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 u want to cache the target table and
insert new rows into cache and the target,u can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.
shared cache: U can share the lookup cache between multiple
transactions.U can share unnamed cache between
transformations inthe same maping.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
what is size of u r database?
Define joiner transformation?
How does a sorter cache works?
How do you use reject loader.
What is event and what are the tasks related to it?
what is the size of u r source(like file or table)?
What is the benefit of session partitioning?
What is fact table? Explain the different kinds of facts.
What are the issues you have faced in your project? How did you overcome those issues?
Target increases every day even though no new record was inserted
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the guidelines to be followed while using union transformation?
What is the difference between informatica 7.0 and 8.0?
What are mapplets? How is it different from a Reusable Transformation?
