Business Objects - Explain scenario where you would use theta Join in Business objects ?

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

Go To First | Previous Question | Next Question

Business Objects | Question 204 of 253

Explain scenario where you would use theta Join in Business objects ?

Total Answers and Comments: 2

Last Update: December 24, 2007 Asked by: senthil0613

Sponsored Links

Best Rated Answer

—

Submitted by: chskumar

use of a theta join:

let's assume that we have a customer_look-up table and Age_group look-up table in ur schmea u have a age column in ur customer table u need to match the age column with the age_group table , but u did't find any equality relation in the both tables, then ur going to use this theta join we match the age column in customer table with age_group table's column age_max and age_min we use between operator here.

theta join: table1.column A Between table.column A and table.column B.
link tables based on relationship other than quality between 2 columns......

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

December 19, 2007 21:44:24

ravi_kumar_garre

Member Since: November 2007 Contribution: 35

RE: Explain scenario where you would use theta Join in Business objects ?

Hi
Use of Theta join in BO:
consider you have a table called "Customer" having AGE one column. And another table called "AGE_GROUP" with coulmns MAX_AGE and MIN_AGE. If you want to have age range as a dimension or Detail in BO then u will have join from Customer-AGE to AGE_GROUP-MAX_AGE and AGE_GROUP-MIN_AGE. Then BO automatically shows BETWEEN in drop down box for Join (normally u found < > ..etc).

Hope this will help you to understand Theta Join in BO.

Regards
Ravi Kumar Garre

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 24, 2007 12:19:10

chskumar

Member Since: December 2007 Contribution: 7

RE: Explain scenario where you would use theta Join in Business objects ?

use of a theta join:

let's assume that we have a customer_look-up table and Age_group look-up table in ur schmea u have a age column in ur customer table u need to match the age column with the age_group table but u did't find any equality relation in the both tables then ur going to use this theta join we match the age column in customer table with age_group table's column age_max and age_min we use between operator here.

theta join: table1.column A Between table.column A and table.column B.
link tables based on relationship other than quality between 2 columns......

Is this answer useful? Yes | No

1 0

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