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


in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?

Answers were Sorted based on User's Feedback



in which situations we go for pesistent cache in lookup and which situations go for shared lookup..

Answer / naga

If the lookup does not change between sessions, you can
configure the transformation to use a persistent lookup
cache. When you run the session, the Integration Service
rebuilds the persistent cache if any cache file is missing
or invalid.

Is This Answer Correct ?    6 Yes 0 No

in which situations we go for pesistent cache in lookup and which situations go for shared lookup..

Answer / sbvp

1.persistent is session level. it increase the perfomance.
it is useful for mutliple session runs.
2.if we want to lookup on mutli t/r's we go for shared
lookup


thanks
sbvp

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,


Sequence generator, when you move from develoment to production how will you reset

0 Answers  


What is data transformation manager process?

0 Answers  


Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  


what is parameter file?

1 Answers   Cap Gemini,


which transformation uses cache?

3 Answers   Keane India Ltd,


what is confirmed dimension?

6 Answers  


Is there any model difference between ODS and DWH

2 Answers   Zensar,


What are the different options available for update strategy?

0 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  


In ur current projectu have done any performance tuning of mappings?

1 Answers  


Categories