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
In how many ways we can create ports?
What is the use of code page?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
have u done any performance tuning? how u ll do?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain sessions. Explain how batches are used to combine executions?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Differentiate between Load Manager and DTM?
what is SDLC way of code development?
What if the source is a flat-file?
What are the tuning techniques you applied during your last project
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Where do we use mapping variables in informatica?
What does update strategy mean, and what are the different option of it?
