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

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1947


where are the log files generally stored.Can you change the path of the file.what can the path be?

2417


what is dynamic insert?

2183


Explain what is etl process? How many steps etl contains explain with example?

875


How etl testing is different from database testing?

1018


how do u set partition points in the mapping?

2572


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

2163


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2208


What are the etl testing operations includes?

1085


Do we need an etl tool?

978


What is tracing level and what are the types?

941


how does the server recongnise the source and target databases.Elaborate on this

2673


Which transformation we use to convert 'NA' to 'Not Available'

1254


What are the types of Data Warehouse applications?

1002


what is the difference steps for data modeling?

2120