What is a join? Explain different types of joins?

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


Please Help Members By Posting Answers For Below Questions

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1771


How to create Index to the table in the universe designer and how it improves the Query performence

2260


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

812


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

9694


Explain 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)?

681






any difficulitis have you phase while creating bo reports and how did u solve it

3103


Explain in detail about type 2(scd),

726


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?

676


is it possible to export the webi reports to crystal reports?with out using businessview?

1954


How to restrict password to a user while sending a document in .pdf format

1963


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3463


Give some information on report bursting?

672


What are the steps to do to use alerts in bo?

735


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1618


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4079