HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
- 2 Answers
- 15526 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vidya
Short cut Join providing an alternative path between two
tables,bypassing intermediate tables, leading to the same
result,regardless of direction. Optimizes query time by
cutting long join paths as short as possible.
Theta join Link tables based on a relationship other than
equality between two columns.
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / vams_gk
shortcut join :it is direct join between source and
destination
example :country-->region--.city
we can coneect country and city using shortcut join
theta join :non equality condition between two tables
| Is This Answer Correct ? | 6 Yes | 6 No |
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
(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.
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain is there any other repository domains rather than universe, security, document?
How would I achieve Traffic Lighting in Business Objects
explain merge dimensions with real time in DWH?
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
what is custom sorting?how we can do this expalain with procedure???
Explain which versions are used in the bo dashboard work?
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
Teradata 
