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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can u generate reports in Informatica?

1092


What is primary and backup node?

1136


What are the components of Informatica? And what is the purpose of each?

1056


Explain joiner transformation in informatica

1128


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10688


Sequence generator, when you move from develoment to production how will you reset

2043


Write the unconnected lookup syntax?

1085


What is the difference between informatica 7.0 and 8.0?

1017


Make a note of the quantity vaults made in informatica?

988


What is flashback table ? Advance thanks

1943


What all join we can perform in LOOKUP transformation?

982


What is joiner transformation?

1011


Define the various join types of joiner transformation?

989


What is source qualifier transformation in informatica?

1014


What are the new features of informatica 9.x developer?

970