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
any difficulitis have you phase while creating bo reports and how did u solve it
Explain is there any other repository domains rather than universe, security, document?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What are all difference between business objects 6.5 and xi r2?
How we drill up week to month?
what is xcelsius architecture?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Differences between business objects and web intelligence reports?
Explain about a time when you discovered a more efficient way to do a work task?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
How to create Index to the table in the universe designer and how it improves the Query performence
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...
What is Indexing? how did u implement indexing?
What is difference between webi and infoview?