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 incremental aggregation?

1135


How can we improve session performance in aggregator transformation?

1152


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1079


What are the designer tools for creating transformations?

1158


What is dynamic cache?

1085


What are the settings that you use to configure the joiner transformation?

1102


whats the logic to load the lower level of granularity of data to fact table.

2309


What is depict expression change?

1192


Mention some types of transformation?

1095


How identifying bottlenecks in various components of informatica and resolving them?

1176


Write the unconnected lookup syntax?

1130


What is joiner transformation in informatica?

1099


What is informatica?

1218


Design time, run time. If you don't create parameter what will happen

1892


expain about the tune parameters?

2457