Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6479 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / punnaiahbabu
Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
How do u Receive requiremnts from the client?
IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?
what is performance tunning in BO in report level& designer level?
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
Can we create universe with no cache??
it is possible to link two universes of separate functional domain ?
How can you access your repository with different user profiles?
what is drill down?
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
Hi, How to navigate one report to another report in webi? Thanks in Advance
generally how do we get information for creating universes and reports
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Teradata 
