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 |
Explain about a time when you discovered a more efficient way to do a work task?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
how to prepare the documentation in business objects and where to get the requirement?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
what is prompt? Cascading prompt? Syntax
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What are different types of saving options in web intelligence?
how to test reports in businessobjects?