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

Performance wise which is better joiner or look up ?
Give me with example?

Answer Posted / abhinaw prakash

There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by SOA of Informatica?

963


What is parallel processing in informatica?

1687


How to update source definition?

1076


What is workflow manager?

1028


How can we use batches?

1005


What is the difference between router and filter?

1242


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2544


What are the different clients of powercenter?

1040


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

955


can anyone explain me about retail domain project in informatica?

7928


Separate from an archive server and a powerhouse?

943


How can you increase the performance in joiner transformation?

1181


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1263


wat are deployement groups in informatica, how it will be used for developers

1700


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1058