What are the types of lookup caches?
- 10 Answers
- 66385 Views
- Accenture, IBM, Informatica, I also Faced
- E-Mail Answers
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
Differentiate between a repository server and a powerhouse?
How to load data in informatica ?
Design a mapping to load a target table with the following values from the above source?
How to use procedural logic inside infromatica?
Differences between version 7.x and 8.x.
Define sessions in informatica etl?
What do you understand by SOA of Informatica?
What is workflow manager?
What is a rank transform?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Reusable transformation and shortcut differences
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what are 3 tech challenges/ common issues you face?
What are the advantages of using informatica as an etl tool over teradata?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
