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
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:
Which command using Query Analyzer will give you the version of SQL server and operating system ?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
(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.
What is report template in b.o?
what will be the contents for a functional requirements specifications
What is Indexing? how did u implement indexing?
Explain difference between zabo and webi?
How to create Index to the table in the universe designer and how it improves the Query performence
When we use aggregate awareness function in designer?
What is the profile and package?
U r project in which stage in implementation?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
what is the difference b/w the refresh and buffered data?
What task is 98% of the required work of a business analyst?
