Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
- 2 Answers
- 16215 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 |
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
Can i use personal database connection to the Webintellegence reports?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
What is casual dimension?
What is the difference between Thin client & thick client?
How to execute the plsql procedure from the report by clicking with mouse?
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
every alternative row should be hilighted ? how u can ?
What are steps to be taken care to create a good Universe?
how can i add two different reports in the same document?
Teradata 
