Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / saradhi
Thank u so much srinu ......
Ur answer gaves me one idea..................
Is This Answer Correct ? | 1 Yes | 4 No |
what is session parameters?
What are the differences between source qualifier and joiner transformation?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
What is the main difference between a Joiner Transformation and Union Transformation?
Explain 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?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is meant by active and passive transformation?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
What are the tasks that source qualifier performs?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?