Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?..

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

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?..

Answer / rayudu

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

Post New Answer

More Informatica Interview Questions

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


What is metadata reporter?

1 Answers   Informatica,


Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  


in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,


What is joiner transformation?

0 Answers  


Differentiate between source qualifier and filter transformation?

0 Answers  


how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,


Categories