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 one is better in joiner and lookup transformation?why?explain clearly?



performance wise which one is better in joiner and lookup transformation?why?explain clearly?..

Answer / venubyna1

Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,


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

1 Answers   Deloitte,


What are the types of groups in Router transformation?

1 Answers   Informatica,


MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  


What are the different types of Type2 dimension maping?

2 Answers   CTS,


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,


What are the join types in joiner transformation?

1 Answers   Informatica,


how to improve performence by using sorted input in aggrigator t/r.

2 Answers  


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


Categories