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

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

Answer Posted / vidya

Short cut Join providing an alternative path between two
tables,bypassing intermediate tables, leading to the same
result,regardless of direction. Optimizes query time by
cutting long join paths as short as possible.

Theta join Link tables based on a relationship other than
equality between two columns.

Is This Answer Correct ?    14 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is there any default username & pwd for bo designer & supervisor?

946


How to restrict password to a user while sending a document in .pdf format

2270


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4252


What is the difference in creating filters in designer and business objects?

977


Can we configure two instances of CMS pointing to two different CMS system databases?

1966


Explain what three things do you consider to be the most important factors for a manager?

938


When to use local filter and when to use global filter?

943


Explain what is the difference between slice and dice and cross tab report?

1017


U r project in which stage in implementation?

2457


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1465


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

980


What is the difference between the public object&schema object?

1002


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2033


Explain about a task that really tested your analytical abilities?

1188


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1786