Explain about Short cut join?
Answers were Sorted based on User's Feedback
Answer / 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 |
hi,
to detect joins automatically go to insert-joins-detect joins..
| Is This Answer Correct ? | 0 Yes | 1 No |
what are the complex reports you have created. Tell me with example?
How to Shedule the reports in Xi R2
i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is a join? Explain different types of joins?
what is master-detail report
Can we do the slice and dice in webintellegence?
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
define universe parameters?
Steps to create alias and apply
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
Can we have multiple domains?