please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
- 2 Answers
- 5339 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / babu
Equai join: Matching records based on equality condition is
satisfied in the both the tables.
Left puter jion:All Records from left table only matcning
records form right table.
Right outer join:All records from right table and only
mating rows from left table.
theta join:Mating the records based on other than the
euality(ex:Age,Marks)
Self Join:It's a join with itself is called self join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
can anybody tell me about complicated object you have created
Explain in detail about type 1?
What is the difference in creating filters in designer and business objects?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is thumbnail?
Can anybody tell me what are the tuning problems?
Which versions are used in the bo dashboard work?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain when to use local filter and when to use global filter?
Differences between business objects and web intelligence reports?
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.
Can Bo generates the Report from the cubical data Explain?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
