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

Hi,
Lookup() is what kind of join ?

Answer Posted / vamse

not necessarily left outer join. Its inner join most of the time.
Loop up is generally used to fetch data for a particular filter condition.(matching critria should take a particular value from it.
Main table is usually large and look up table is small in ideal scenario.

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between Data Warehousing and Data Mining?

1004


how would u estimate the size of Aggregator transform data and index cache?

2396


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2140


How many steps etl contains explain with example?

908


How to fine tune mappings?

898


what is pmrep command?

11508


List few etl bugs?

896


what is different between sequential batch and concurrent batch and which is recommended and why?

4882


What is etl process?

890


what are the reports developed in sap bw project and what is the requirement for developing it?

2146


what is pmrep command?

2388


what is a worklet?

944


what are the reporting tools and difference between them?

2037


What is tracing level and what are the types?

918


what make u disappointmnets in u r career

2163