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


Please Help Members By Posting Answers For Below Questions

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2993


Explain the difference between detect alias and detect context?

618


Explain when to use local filter and when to use global filter?

603


What is report template in b.o?

580


What are the steps to do to use alerts in bo?

627






BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1717


Can Bo generates the Report from the cubical data Explain?

1626


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1615


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4180


How can you first report in Business Objects by using broadcast agent?

2596


What is Indexing? how did u implement indexing?

1810


how to create metric universe ?

1893


Explain what is aggregate table and aggregate fact table ... Any examples of both?

603


what is the difference b/w the refresh and buffered data?

1759


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

621