What is a join? Explain different types of joins?

Answer Posted / vams_gk

join is very imp concept in BO

relation between two tables is called joins.
we have 4 types of join relations 1:m,m:1,m:m,1:1

types of joins in BO
1)equi join
2)theta join
3)outer join(left/right)
4)isolated join
5)short cut join

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what would you consider as your biggest achievement and why?

579


What Is The Difference Between Oltp And Olap?

682


how to create reports on screech?

2081


What is the profile and package?

1768


Can Bo generates the Report from the cubical data Explain?

1628






explain in detail about type 3?

632


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

635


When to use local filter and when to use global filter?

603


How we drill up week to month?

620


U r project in which stage in implementation?

1950


Give some information on report bursting?

573


What is the difference between user and versatile user?

585


What are the steps to be taken to schedule the report?

558


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

9444


What is Indexing? how did u implement indexing?

1820