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
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?
Explain about a tricky situation for which you found a very simple solution?
How to schedule the report in b.o?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What three things do you consider to be the most important factors for a manager?
Difference between zabo and webi?
Explain when we use aggregate awareness function in designer?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Which versions are used in the bo dashboard work?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain what is aggregate table and aggregate fact table ... Any examples of both?
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 ?
how get the grand total in master-detail report?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Can we create universe with no cache??
