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?



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

Answer / 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

More Informatica Interview Questions

What are set operators in Oracle

3 Answers   Deloitte, Wipro,


In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,


Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,


Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  


Could you explain what is enterprise data warehouse?

0 Answers  


What is the need of etl tools?

0 Answers  


What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  


Define maping and sessions?

3 Answers  


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  


how to duplicates from expression transformation without using sorter before that

1 Answers  


what is session override?

2 Answers   Cap Gemini,


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


Categories