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

which is better perfomancewise lookup or joiner and why?can anyone give example?

Answer Posted / 78swapnil

All you guys are correct. But there is a major difference between lookup and joiner is, when you join the table we need to join on the basis of a join condition (=) but in case of lookup you can get the data join conditions like (=,!=,<=,>=).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is standalone command task?

1306


Which version configuration tool used in ur project?

3235


What is exclusive and normal mode for repository services?

1125


What is informatica powercenter repository?

1171


how we can load rejected record's at run time?(not through bad files)

2358


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6450


Make a note of the quantity vaults made in informatica?

971


explain about unit testing? in real time?

2181


which one is better performance wise joiner or look up

1073


While migrating the data from one environment to another environment how would you manage the connections?

1074


What are the different ways to implement parallel processing in informatica?

1395


what is the -ve test case in your project.

2393


what is the difference between informatica6.1 and infomatica7.1

2252


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1067


Is it possible to define a single node as a Gateway node as well as worker node?

1105