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
- 18470 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 are ETL Tools?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Can we create two repositories on same database instance in oracle?
What are the components of workflow manager?
What is joiner transformation in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is an expression transformation in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
scenario where i can use only concurrent execution of workflow.
State the differences between sql override and lookup override?
How you can differentiate between connected lookup and unconnected lookup?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Define sessions in informatica etl?
Why filter transformation is an active one?
