Answer Posted / subhash
Join is used to link to tables depending upon the data
requested by the user, Usually we have Inner Join, Outer
Join, Left Join, Right Join, Full Outer join.
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What task is 98% of the required work of a business analyst?
Explain what would you consider as your biggest achievement and why?
What are all difference between business objects 6.5 and xi r2?
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?
How many universes can be created in a project?
Explain in detail about type 2(scd),
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
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?
(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.
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
How to create Index to the table in the universe designer and how it improves the Query performence
Difference between b.o 5.1 and 6.1b?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
what is xcelsius architecture?
How to open a universe with out using the Designer ??
