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

What Is The Difference Between Oltp And Olap?

680


Can we configure two instances of CMS pointing to two different CMS system databases?

1491


What are the data types present in bo? What happens if we implement view in the designer and report?

622


what will be the contents for a functional requirements specifications

1790


How many universes can be created in a project?

599






Differences between business objects and web intelligence reports?

654


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1829


What we need to discuss with designer before starting the universe designing.

1822


Can anybody tell me what are the tuning problems?

1592


Explain difference between zabo and webi?

656


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

579


Can more than 1 metric be applied on an analytic in business objects?

1659


What is difference between custom hierarchy and report based hierarchy?

551


Explain which versions are used in the bo dashboard work?

635


Can Bo generates the Report from the cubical data Explain?

1628