Answer Posted / srikanth
A cache is a memory area where informatica server holds the
data to perform calculations during the session. It
creates cache files in the $PMcachedir and as soon as the
session finishes, server deletes the cache files from the
directory.
if we know the data does not change between session runs,
we can persist on the disk (persistent cache ) and use
those files in other sessions. in this case, the server
does not delete the cache files as soon as the session
finishes.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
Explain load alternative records / rows into multiple targets - informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain pushdown optimization and types in informatica
What is transformation?
Is it possible to use a client with different version than that of its Informatica server?
What is informatica?
Define filter transformation?
Briefly explain the aggregator transformation?
How to do unit testing in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is the -ve test case in your project.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is incremental aggregation?
What are the performance considerations when working with aggregator transformation?