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

how to create reports on screech?

2076


What is the dense rank?

671


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

691


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2995


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1883






What Is Snow Flake Schema?

666


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

584


Explain about a tricky situation for which you found a very simple solution?

539


Explain in detail about type 1?

650


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1689


How to execute the plsql procedure from the report by clicking with mouse?

615


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9876


Differences between business objects and web intelligence reports?

651


Can we Save (save as) WEBI Doc as DESKI?

7064


8. How much supervision have you typically received in your previous job?

1830