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 |
What is domain? How many are there in a basic setup? What are they?
how u restrict the values?to display 5 values insted of 10 values?
What is security domain in Business Objects?
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?
What are the data types present in bo? What happens if we implement view in the designer and report?
which is the best way to resolve loop context r alias why?
How many tables can an universe contain is their any limit to insert tables in the universe?
How can you access your repository with different user profiles?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
What is the pivot option ? what is the need of it?
What is the difference between absolute and relative div positioning?