Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
Answer Posted / dl
few more additions to the above answer.....
1.Dynamic lookup allows to modify cache where as
persistentlookup does not allow us to modify cache.
2.Dynamic lookup use 'newlookup row', a default port in the
cache but persistent does use any default ports in cache.
3.As session completes dynamic cache removed but the
persistent cache saved in informatica power centre server.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is a sequence generator transformation?
Enlist the various types of transformations.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is the benefit of session partitioning?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How are indexes created after completing the load process?
What do you mean by worklet?
What is target designer and target load order?
What is the need for an etl tool?
Explain the mapping variable usage example in informatica
State the limitations where we cannot use joiner in the mapping pipeline?
Differences between version 7.x and 8.x.
How you know when to use a static cache and dynamic cache in lookup transformation?
Define mapplet?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?