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 will we use unconnected & connected lookup? How it
will effect on the performance of mapping?

Answer Posted / jeevan kumar medapati

if u want to perform look up on less values then we go for
connected lkp
if u want to perform look up from more than one table then
we go for un connected lkp
in ur source u have more date columns then we should go for
unconnected lkp.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by worklet?

1017


Define mapping and session?

973


What can we do to improve the performance of informatica aggregator transformation?

1045


permutations of mapplet

2456


Explain why we use partitioning the session in informatica?

1008


How does the aggregator transformation handle null values?

1087


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6912


How do you load alternate records into different tables through mapping flow?

1808


Why do we need informatica?

928


What is difference between a gateway node and worker node?

1069


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1197


What are roles and groups and benefits of using them?

992


What are mapplets? How is it different from a Reusable Transformation?

1034


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1928


What does cheating measurement mean?

998