Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
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.
Explain what are the measure objects?
Explain what task is 98% of the required work of a business analyst?
How to schedule the report in b.o?
How to restrict password to a user while sending a document in .pdf format
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
explain in detail about type 3?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
What is the difference between user and versatile user?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is Indexing? how did u implement indexing?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
