What is a join? Explain different types of joins?
Answers were Sorted based on User's Feedback
Answer / nareshkumar
A join is a condition that links the data in seperate but
related tables. The tables usually have a parent-child
relationship. If a query does not contain a join, the
database returns a result set that contains all possible
combinations of the rows in the query tables.
Types of joins:
1) Equi-Joins
Link tables based on the equality between the values in the
column of one table and the values in the column of another.
2) Theta Joins
Link tables based on a relationship other than equality
between two columns.
3) Outer Joins (Left Outer, Right Outer, Full Outer)
Link two tables, one of which has rows that do not match
those in the common column of the other table.
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.
5) Self restricting joins
Single table join used to set a restriction on the table.
Is This Answer Correct ? | 24 Yes | 4 No |
Answer / subhash
Join is used to link to tables depending upon the data
requested by the user, Usually we have Inner Join, Outer
Join, Left Join, Right Join, Full Outer join.
Is This Answer Correct ? | 14 Yes | 5 No |
Answer / 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 |
Answer / 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 |
Answer / srinu
Combining a data from multiple tables is called join.
There r 5 types of joins r there.
1)Simple join 2)Equi join 3)Outer join 4)Theta join
5)Short cut join
Is This Answer Correct ? | 4 Yes | 11 No |
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
I have all the latest SAP – Business Objects - XI Certification Dumps, SABE201: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level One SABE301: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level Two SABE401: BUSINESS OBJECTS Enterprise Certified Professional XI – Level Three SABE501V3.0: BUSINESS OBJECTS Certified Professional – BUSINESS OBJECTS Enterprise XI 3.0 – Update. RDCR201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR301:1 BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR08301: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08401: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 QAWI201V3.0: BUSINESS OBJECTS Certified Professional Web Intelligence XI 3.0 QAWI301V3.0: BUSINESS OBJECTS Certified Professional BUSINESS OBJECTS Web Intelligence XI 3 DMDI201: BUSINESS OBJECTS Data Integrator XI – Level One DMDI301: BUSINESS OBJECTS Data Integrator XI – Level Two You can get Guarantee Pass 100 % Score with these Dumps, If interested in any of the dump, drop me a mail to: srivatsav.2k5@gmail.com with Certification code
I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
what is static filter and dynamic filter
What are the differences between webi and deski of XI R2 not the earlier versions
Explain how many universes can be created in a project?
What is aggregate table and aggregate fact table ... Any examples of both?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
how can u find the granularity in fact table
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?