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 in detail about type 1?
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)?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to restrict password to a user while sending a document in .pdf format
What is the difference between condition & filter?
what is document design in boxi,have u participate in that
How would you format some text using css to be verdana and bold?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain the difference between detect alias and detect context?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain the data types present in bo and what happens if we implement view in the designer and report?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What are the data types present in bo? What happens if we implement view in the designer and report?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
