Business Objects - Shortcut Joins

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 224 of 253

Shortcut Joins

What is the use of a shortcut joins and explain with realtime usage

Total Answers and Comments: 2

Last Update: May 13, 2008 Asked by: kamal.7923

Sponsored Links

Best Rated Answer

—

Submitted by: ganesh.hbad

short cut joins are used to improve the query performance at universe level.
Suppose if we have 4 tables A,B,C and D

A--->B---->C---->D and there is a chance to link A--->D but we should not link (causes loop) and we need data from the tables A and D then it will get the data in the path A--->B---->C---->D , it consumes lot of time and resources.

In this case instead of linking A---->D using normal join we should link A and D by using short cut join and this will not create any loop and get the data in the path
A--->D, it consumes less time and resources.

Above answer was rated as good by the following members:
Sindhunarayana, prasanna.ramesh1, ASHOK1324

April 17, 2008 14:22:43

ganesh.hbad

Member Since: April 2008 Contribution: 2

RE: Shortcut Joins

short cut joins are used to improve the query performance at universe level.
Suppose if we have 4 tables A B C and D

A--->B---->C---->D and there is a chance to link A--->D but we should not link (causes loop) and we need data from the tables A and D then it will get the data in the path A--->B---->C---->D it consumes lot of time and resources.

In this case instead of linking A---->D using normal join we should link A and D by using short cut join and this will not create any loop and get the data in the path
A--->D it consumes less time and resources.

Is this answer useful? Yes | No

3 0

Overall Rating: +3

May 12, 2008 08:23:53

anuanu

Member Since: May 2008 Contribution: 3

RE:

As per my knowledge shortcut join will resolve the loop automatically.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Service Oriented Java Business Integration Review

Service Oriented Java Business Integration Review Introduction If you ve read through the texts which give you an introduction to SOA or Web Services you will often find them to be quite frustrating and the reason for this is because they spend too much time referencing business processes which are

Business Intelligence Key Performance Indicators

Business Intelligence Key Performance Indicators What are Key Performance Indicators Key Performance Indicators are also known as Key Success Indicators they help an organization to better define and measure their progress toward professional goals Once an organization has clearly identified its nee

How to Best Use Business Intelligence to Your Advantage

How to Best Use Business Intelligence to Your Advantage It is no big secret that today s businesses rely heavily on data and the information it delivers about their companies Whether it is for the purpose of customer acquisition improving operational performance or understanding competitors all of t

Business Intelligence in Information Technology

Business Intelligence in Information Technology IT stands for Information Technology Information Technology is a system designed to gather process or distribute information IT can be inspected in terms of the following three groupings; the data gathering the data processing and the data distribut

Breaking up XML into Relational Data

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data This reverse operation can be useful if your application works with relation

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat

Retrieving XML Data

Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the

Business Intelligence Integration

Business Intelligence Integration How to Integrate Business Intelligence within Your Organization Before you Integrate Business Intelligence into your Organization Business Intelligence has developed into strategic process over the years of its extraordinary growth even so it still needs to be incor

Business Intelligence Tips

Business Intelligence Tips Understand Your Organization first Truly understanding your company and how it works is perhaps one of the most important Business Intelligence tips anyone can offer This includes understanding the business itself the processes involved the data and how that data is used b

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM

Related Categories

—

User Name		Remember Me?
Password

Question Bank