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

Explain about Short cut join?

Answer Posted / anu

A shortcut join is a join that provides alternate path
between two tables.Shortcut joins improve the performance
of a query by not taking into account intermediate tables,
and so shortening a normally longer join.
A common use of shortcut joins is to link a shared lookup
table to another table further along a join path. The join
path comprises several different tables in the same
context. In such a case, the shortcut join is only
effective when the value being looked up has been
denormalized to lower levels in a hierarchy of tables, so
the same value exists at all the levels being joined.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is universe null

2406


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1018


what are the day to day activities of BO administrator ?

3013


any difficulitis have you phase while creating bo reports and how did u solve it

3433


How would you format some text using css to be verdana and bold?

1059


What is thumbnail?

957


Did you face any problems while creating reports? Name? Solutions?

3681


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

1332


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4393


Explain when we use aggregate awareness function in designer?

1014


How we drill up week to month?

1051


What Is The Difference Between Oltp And Olap?

1103


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

1049


How to open a universe with out using the Designer ??

7555


explain in detail about type 3?

1003