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 are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What sort of existing documents should business analysts refer to when starting on a new project?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
any difficulitis have you phase while creating bo reports and how did u solve it
Can you please send me the migration related issues .
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
how to create reports on screech?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is report template in b.o?
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
When we use aggregate awareness function in designer?
What is the functional & architectural differences between business objects and web intelligence reports?
