Answer Posted / 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 |
Post New Answer View All Answers
Explain is there any default username & pwd for bo designer & supervisor?
How to restrict password to a user while sending a document in .pdf format
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What is the difference in creating filters in designer and business objects?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain what three things do you consider to be the most important factors for a manager?
When to use local filter and when to use global filter?
Explain what is the difference between slice and dice and cross tab report?
U r project in which stage in implementation?
(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 as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the difference between the public object&schema object?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain about a task that really tested your analytical abilities?
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