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
Can we Save (save as) WEBI Doc as DESKI?
Give some information on report bursting?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what three things do you consider to be the most important factors for a manager?
Explain how we drill up week to month?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How were the reports scheduled and how to resolve unexecuted documents?
What is a fantrap in business objects?
Explain when to use local filter and when to use global filter?
What is a bo repository?
Explain difference between zabo and webi?
What is the dense rank?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY