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 what would you consider as your biggest achievement and why?
what is incompactabulity error in sap bo
1.what is context? How u create? With example.
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
why measure objects are semantically dynamic?
Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com
can i use stored procedure in webi?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is shortcut join?could give any one example?
When we go for OLAP , and When we go for OLTP for generating the reports ?
what is diff between webi,deski,infoview
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?