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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / jey.dgl

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

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

why we r using presql&postsql in source qualifier?

1 Answers   HP,

How to start a workflow using pmcmd command?

0 Answers  

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

How to extract the informatica rejected data?

0 Answers  

What is Cognos script editor?

0 Answers   Cognizant,

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

What are the two modes of datamovement in informatica sever?

2 Answers  

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

What is difference between a gateway node and worker node?

0 Answers  

For more Informatica Interview Questions Click Here
Categories