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


Which one is better performance wise connected/un-connected
lkp?why?

Answers were Sorted based on User's Feedback



Which one is better performance wise connected/un-connected lkp?why?..

Answer / rayudu

Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .


Regards,
rayudu.

Is This Answer Correct ?    18 Yes 3 No

Which one is better performance wise connected/un-connected lkp?why?..

Answer / yamini

Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,


source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,


How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


What is power center repository?

1 Answers  


How do you load first and last records into target table?

0 Answers  


Write the unconnected lookup syntax?

0 Answers  


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


Categories