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
- 18489 Views
- I also Faced
- E-Mail Answers
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
How is union transformation utilized?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What all join we can perform in LOOKUP transformation?
what is the -ve test case in your project.
What are the types of schemas we have in data warehouse and what are the difference between them?
how to load rows into fact table in data warehouse
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is rank transformation in informatica
What is expression transformation?
How union transformation is used?
What is the difference between writing a joiner query in ANSI style and THETA style?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
draw informatica architecture 8.6 ?
