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 sort of existing documents should business analysts refer to when starting on a new project?

726


What is thumbnail?

693


How to generate the report from excel sheet?

735


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


Explain about a task that really tested your analytical abilities?

905






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

697


What would you consider as your biggest achievement and why?

723


can anybody tell me about complicated object you have created

2869


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

732


What are all difference between business objects 6.5 and xi r2?

724


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1658


how to create metric universe ?

2028


what are the day to day activities of BO administrator ?

2452


Explain is there any default username & pwd for bo designer & supervisor?

714


what are the tables used in health care domain project and columns used in report?

4167