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

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

Question Posted / dathu

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

What is the difference between view and materialised view?

4 Answers  

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

what is the -ve test case in your project.

0 Answers   CTS, TCS,

What are the differences between oltp and olap?

0 Answers  

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

What is complex mapping?

0 Answers  

How can we use batches?

0 Answers  

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

For more Informatica Interview Questions Click Here
Categories