Answer Posted / sourabh gosain
Short cut join is a join between 2 tables to improve query
performance. if one face table can be connected to other
fact table to retrieve data, but we are not able to join
that table due to looping problem, then we can connect them
through short cut join. that way join remains invisible for
integrity check. Hence data when selected from 2 tables
comes fast as there is no intermediate table to join them.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the functional & architectural differences between business objects and web intelligence reports?
Explain how many universes can be created in a project?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain in detail about type 1?
Is there any other repository domains rather than universe, security, document?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is top business?
Explain the data types present in bo and what happens if we implement view in the designer and report?
How to open a universe with out using the Designer ??
Explain is data mart?
What is the dense rank?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
what is universe null
Explain what are the steps to do to use alerts in bo?
What are the steps to be taken to schedule the report?