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
- 9499 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 |
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Which are the different editions of informatica powercenter that are available?
what is the difference between mapplet & stored procedure?
what is upstream and downstream transformation?
What could be the possible resons of locks by user?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
How can we create index after completion of load process?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What is the difference Between Mapping parameter and variable
Teradata 
