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

how to join two flat files in informatica?

3 Answers   Wipro,

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

What do you mean incremental aggregation?

0 Answers  

why u go for dimensions ?

3 Answers   TCS,

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

How to use procedural logic inside infromatica?

0 Answers  

Explain what is informatica metadata and where is it stored?

0 Answers  

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

Explain lookup transformation source types in informatica

0 Answers   Informatica,

Is there any model difference between ODS and DWH

2 Answers   Zensar,

Why we use stored procedure transformation?

4 Answers  

For more Informatica Interview Questions Click Here
Categories