Interested to Buy Any Domain ? << Click Here >> for more details...
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
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
How to open a universe with out using the Designer ??
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
what is xcelsius architecture?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How to schedule the report in b.o?
Can you please send me the migration related issues .
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
Did you face any problems while creating reports? Name? Solutions?
Explain what are the steps to do to use alerts in bo?
explain in detail about type 3?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Can we Save (save as) WEBI Doc as DESKI?
how many reports have u created ? explain a few.
What is the difference between condition & filter?
