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
- 18630 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
Explain the types of lookup transformation?
What are the differences between oltp and olap?
How to update a particular record in target with out running whole workflow?
Write the prerequisite tasks to achieve the session partition?
What are the different types of transformation available in informatica.
What is the meaning of decode in informatica?
Differentiate between joiner and lookup transformation?
Explain about Informatica server process that how it works relates to mapping variables?
How you can differentiate between connected lookup and unconnected lookup?
How to generate sequence numbers?
Explain what transformation and how many are there in informatica?
Which are the different editions of informatica powercenter that are available?
Define sessions in informatica etl?
Where do we use mapping variables in informatica?
What is sq transformation?
