Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / veni
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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
what is the complex transformation you used in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Define update strategy?
EXL informatica Questions
What you know about transaction control transformation?
Explain the mapping variable usage example in informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is workflow manager?
How to update source definition?
What is a joiner transformation and why it is an active one?
What is the different lookup cache(s)?
Briefly define a session task?
What all are steps in up gradation of Informatica server?
