Diffrence between static and dynamic cache

Answers were Sorted based on User's Feedback



Diffrence between static and dynamic cache..

Answer / siva prasad

Static cache: Is readonly cache. We cannot insert or update
the records dynamically.

Dynamic Cache: It will refresh the changed data and
allocate a seperate buffer for that.Each time it will
identify the changed data rather than capture entire
data.we can insert or update the records dynamically.

Is This Answer Correct ?    5 Yes 0 No

Diffrence between static and dynamic cache..

Answer / sushma

If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are Rapid changing dimensions?

1 Answers  


How to update records in Target, without using Update Strategy?

3 Answers  


Can we create multiple integration service on single repository?

0 Answers  


Is stop and abort are same in informatica?

0 Answers  


What are the types of caches in lookup?

0 Answers  






What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  


my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,


r u done any partitions in ur project?

0 Answers   TCS,


Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,


What is the difference between Active and Passive transformation?

0 Answers   Informatica,


How to do the error handling of if ur source is flatfiles?

0 Answers  


Categories