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
- 18669 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
What is option by which we can run all the sessions in a batch simultaneously?
According to his methodology what all you need before you build a datawarehouse
How to join three sources using joiner?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are 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?
What can we do to improve the performance of informatica aggregator transformation?
What is a repository? And how to add it in an informatica client?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the difference between informatica 7.0 and 8.0?
What is mapping debugger?
Explain lookup transformation is active in informatica
can we override a native sql query within informatica? Where do we do it? How do we do it?
How can you differentiate between powercenter and power map?
How do you set a varible in incremental aggregation
What is substr in informatica?
