When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 8376 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish konda
Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.
If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.
The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".
So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.
| Is This Answer Correct ? | 4 Yes | 0 No |
If the lookup cache doesnt change between mutiple runs and
if we know that the lookup data doesnt change then we will
go for Persistant cache.
If the loopup cache changes between multiple session runs
and to keep the target table and lookup cache synchronized
we will use dynamic lookup cache .
regards,
rayudu.
| Is This Answer Correct ? | 7 Yes | 4 No |
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
can you use flat file for lookup table?why?
what is mapping optimization? wat are the techniques for tat
What is the use of source qualifier?
what are testing in a mapping level please give brif eplanation
What are the issues you have faced in your project? How did you overcome those issues?
Write the unconnected lookup syntax and how to return more than one column.
What is the difference between router and filter?
What is the difference between view and materialised view?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Teradata 
