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 / m.m.basha

performwise both (connected& unconnected) are best
connected lookup :-it is connected to the source
unconnected loockup:- it is not connected to the source

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transformation?

927


what is diff b/t sorter t/r and agg have the option sorter property...

2128


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2292


What is exclusive and normal mode for repository services?

1061


What is joiner transformation in informatica?

992


Is it possible to use a client with different version than that of its Informatica server?

1073


Difference between Target-based loading and constraint-based loading?

943


What are the limitations of joiner transformation?

1043


how to load dimension table and fact table. plz tell me the steps.

2033


What is Session and Batches?

1039


Explain how many types of dimensions are available in informatica?

1004


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1009


Can we create a Integration service without a Repository service and vice versa?

1169


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1905


What are the types of caches in lookup?

973