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


Using Connected or unconnected lookup for performance wise which one is preferable?.



Using Connected or unconnected lookup for performance wise which one is preferable?...

Answer / sam

Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


How many joins in Informatica

5 Answers   CSC,


How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,


how to join two flat files in informatica?

3 Answers   Wipro,


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,


tell me the rules and responsblites in our project(my project is development)

0 Answers  


how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,


what is scd?

6 Answers  


Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,


What is workflow monitor?

0 Answers  


1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,


What is a joiner transformation?

0 Answers  


Categories