Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / venkatesh
Hi everybody,
whatever NareshKumar explained about the joins is right
except the Shortcut join.
4) Shortcut Joins
Join providing an alternative path between two tables,
bypassing intermediate tables, "leading to the same result,
regardless of direction". Optimizes query time by cutting
long join paths as short as possible.
In the above defination (which is mentioned in the inverted
commas)the result wont be same. It is different.
Example:
There is 4 tables
A,B,C,D
The join in between these 4 tables are like this.
A--B--C--D
Here if I drag A and D tables then I will get 6 rows for
example.
Now Make a shortcut join between A and D
Now if I drag A and D tables then I will get more than 6
rows.Why because
In first join the data is filtering from A to D like below
First A to B then B to C after that C to D.
But in Shortcut there is direct join A to D.Here the data
is not filtering.
Thanks,
Venky
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain how many universes can be created in a project?
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
What three things do you consider to be the most important factors for a manager?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What are the steps to do to use alerts in bo?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are all difference between business objects 6.5 and xi r2?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference between absolute and relative div positioning?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What would you consider as your biggest achievement and why?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
