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
what is universe null
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
what are the day to day activities of BO administrator ?
any difficulitis have you phase while creating bo reports and how did u solve it
How would you format some text using css to be verdana and bold?
What is thumbnail?
Did you face any problems while creating reports? Name? Solutions?
Explain when to use local filter and when to use global filter?
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??
Explain when we use aggregate awareness function in designer?
How we drill up week to month?
What Is The Difference Between Oltp And Olap?
What is the difference between the public object&schema object?
How to open a universe with out using the Designer ??
explain in detail about type 3?