Short cut join is a join between 2 tables to improve query performance. i

What is shortcut join?could give any one example?

Question Posted / sourabh gosain

8 Answers
25043 Views
I also Faced
E-Mail Answers

Answer Posted / sourabh gosain

Short cut join is a join between 2 tables to improve query
performance. if one face table can be connected to other
fact table to retrieve data, but we are not able to join
that table due to looping problem, then we can connect them
through short cut join. that way join remains invisible for
integrity check. Hence data when selected from 2 tables
comes fast as there is no intermediate table to join them.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the functional & architectural differences between business objects and web intelligence reports?

2358

how get the grand total in master-detail report?

2170

8. How much supervision have you typically received in your previous job?

2201

Explain what would you consider as your biggest achievement and why?

922

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2094

Explain is there any default username & pwd for bo designer & supervisor?

945

Explain about alerts in bos, under what situation we need to use alerts?

980

What is the difference in creating filters in designer and business objects?

977

What Is The Difference Between Oltp And Olap?

1054

What is aggregate table and aggregate fact table ... Any examples of both?

999

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

974

What is thumbnail?

916

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

4935

what is xcelsius architecture?

4518

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2127