Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 9252 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 |
Enterprise data warehouse your projects phase by phase explain?
Which kind of index is preferred in DWH?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Define mapping and session?
Define pmcmd command?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
SO many times i saw "$PM parser error " .what is meant by PM?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the new features of informatica 9.x developer?
what is inline view?
COM components can be used in Informatica
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Teradata 
