ravi_kumar_garre

 Profile Answers by ravi_kumar_garre 

• Dec 19th, 2007

 

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

chskumar

 Profile Answers by chskumar 

• Dec 24th, 2007

 

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......