When we r going for Short_cut join & It's Resolution???
Plz provide one scenario??
Answer Posted / kishore babu
if we have 3 tables A,B,C. our requirement is A->B->C &A->C
That means we make three joins. the referential integrity says
joins must be no.of tables-1.so the join A->c join make as a
short cut join.more than 3 tables we dont go for short cut
join.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Difference between zabo and webi?
Is there any other repository domains rather than universe, security, document?
Explain what are the steps to do to use alerts in bo?
What is report template in b.o?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is the difference between absolute and relative div positioning?
what is xcelsius architecture?
How many universes can be created in a project?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
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?
Give some information on report bursting?
What is the difference between the public object&schema object?
what is universe null
What are the steps to do to use alerts in bo?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server