Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
Answer Posted / srinu
Dynamic:--
1)When you use a dynamic cache, the Informatica Server
updates the lookup cache as it passes rows to the target.
2)In Dynamic, we can update catch will New data also.
3) Dynamic cache,Not Reusable
(when we need Updated cache data, That only we need Dynamic
Cache)
Persistent:--
1)a Lookup transformation to use a non-persistent or
persistent cache. The PowerCenter Server saves or deletes
lookup cache files after a successful session based on the
Lookup Cache Persistent property.
2) Persistent, we are not able to update the catch with New
data.
3) Persistent catch is Reusable.
(When we need Previous Cache data, That only we need
Persistent Cache)
I think it will help you.
Any,,,??,,,or ,,corrections let me know,,,,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
explain about unit testing? in real time?
how we can load rejected record's at run time?(not through bad files)
hi real timers . iam waiting for ur reply regarding ETL TESTING
Which transformation is needed while using the Cobol sources as source definitions?
Which version configuration tool used in ur project?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are multi-group transformations?
Target increases every day even though no new record was inserted
How an expression transformation differs from aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
Explain the difference between mapping parameter and mapping variable?
What is target designer and target load order?
what are 3 tech challenges/ common issues you face?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?