Answer Posted / srinu
Combining a data from multiple tables is called join.
There r 5 types of joins r there.
1)Simple join 2)Equi join 3)Outer join 4)Theta join
5)Short cut join
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
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
Explain difference between zabo and webi?
what is the difference b/w the refresh and buffered data?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Can you please send me the migration related issues .
Explain what is the difference between business requirement document and use case document.
Explain in detail about type 1?
Can more than 1 metric be applied on an analytic in business objects?
What is the profile and package?
What is difference between webi and infoview?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain about a task that really tested your analytical abilities?
Can anybody tell me what are the tuning problems?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is a fantrap in business objects?