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


when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.



when do we use static cache and when do we use dynamic cache in lookup transformation? with exampl..

Answer / swapna

static cache is used when the records in the source does not update more frequently.

dynamic cache is used when the records in the source frequently updates.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

how to convert the .doc docs into .txt format using informatica

4 Answers  


Explain how many types of dimensions are available in informatica?

0 Answers  


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  


How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  


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,


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


define galaxy repository in informatica

0 Answers  


what is target load plan

2 Answers   Cap Gemini,


In how many ways we can create ports?

0 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  


Categories