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 / lokesh.t

lookup is having multiple advantages compare to joiner
transformations :-it will avoid duplicate vlues . by
using first last value in lkp values . with lkp we can n
nnumber of tables. where as in joiner we can join only
two tables

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is parallel processing in informatica?

1619


What is a mapplet/worklet in informatica?

1120


can anyone explain me about retail domain project in informatica?

7889


What are the transformations that are not supported in mapplet?

955


How to elaborate powercenter integration service?

1072


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1925


What is the function of union transformation?

1063


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2057


Explain pushdown optimization and types in informatica

1015


What are the uses of etl tools?

1065


How do you change a non-reusable transformation to reusable transformation?

942


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1102


what is the size of your data warehousing?

2042


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1977


What is decode in static cache?

1077