Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
- 3 Answers
- 17308 Views
- I also Faced
- E-Mail Answers
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 |
How to delete the (flat file) data in the target table after loaded.
how much memory (size) occupied by a session at runtime
What are the measure objects?
what are the real time problems generally come up while doing or running mapping or any transformation?
what is the size of your data warehousing?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
can you avoid static cache in the lookup transformation? I mean can you
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
what is the difference between mapplet & stored procedure?
What is rank transformation?
Teradata 
