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 are different types of transformations available in informatica?

1060


permutations of mapplet

2550


What you know about transaction control transformation?

1059


Suppose we do not group by on any ports of the aggregator what will be the output?

1098


Define mapplet?

1059


Reusable transformation and shortcut differences

1884


Mention some types of transformation?

1097


Which transformation should we use to normalise the COBOL and relational sources?

1272


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2370


What are the types of schemas we have in data warehouse and what are the difference between them?

989


Explain the different dimensions.

1009


What is an aggregator transformation?

1146


How can you increase the performance in joiner transformation?

1248


How to differentiate between the active and passive transformations?

1230


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2090