Interested to Buy Any Domain ? << Click Here >> for more details...
Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
- 3 Answers
- 18686 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 do u use sequence created in oracle in informatica? Explain with an simple example
What is depict expression change?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
If u select groupby port in aggregator what is output and dont select groupby option what is output
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
what is procedure to use mapping variable in source qualifier transformation? with example
Design a mapping to get year of join for each employee.
What is the difference between bitmap and btree index?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What does command task mean?
what is diffrence b/w joner and union transfermation
Teradata 
