Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
- 2 Answers
- 16071 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 |
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the difference between derived table and views? which one gives better performance?
Explain is there any other repository domains rather than universe, security, document?
How can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
it is possible to link two universes of separate functional domain ?
What is the difference b/w breaks and sections
what is xcelsius architecture?
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
Can we create universe with no cache??
Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.
Teradata 
