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

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

How will the document be delivered to me?

0 Answers  

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

What are mapping parametres and variables in informatica?

6 Answers   TCS,

what is upstream and downstream transformation?

7 Answers  

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

why we use stored procedure transformation?

4 Answers   IBM,

How can we create index after completion of load process?

0 Answers  

For more Informatica Interview Questions Click Here
Categories