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
- 6485 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
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?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain is there any other repository domains rather than universe, security, document?
How to create Index to the table in the universe designer and how it improves the Query performence
what is xcelsius architecture?
Can we configure two instances of CMS pointing to two different CMS system databases?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain how many universes can be created in a project?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
can anybody tell me about complicated object you have created
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain in detail about type 1?
