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

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

What is active and passive transformation?

10 Answers  

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

What is decode in static cache?

0 Answers  

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

How to load time dimension?

1 Answers   Ford,

which one is better performance wise joiner or look up

0 Answers   Informatica,

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

What is dimensional table?

0 Answers  

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

what is degenerated dimension

6 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories