ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Answer
# 1		 
Short cut Join providing an alternative path between two 
tables,bypassing intermediate tables, leading to the same 
result,regardless of direction. Optimizes query time by 
cutting long join paths as short as possible.

Theta join Link tables based on a relationship other than 
equality between two columns.
 
Is This Answer Correct ?    8 Yes 2 No
Vidya
 
  Re: HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Answer
# 2		 
shortcut join :it is direct join between source and 
destination
 example :country-->region--.city

we can coneect country and city using shortcut join

theta join :non equality condition between two tables
 
Is This Answer Correct ?    4 Yes 3 No
Vams_gk
 
 
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report ) Exilant5
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)? TCS1
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?  2
what is fantrap and chasmtrap ? Tech-Mahindra2
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?  1
what are they different types of report in BO?  2
how to test reports in businessobjects? TCS5
Explain about derived tables? Cap-Gemini1
What is a universe? TCS6
10.why we are going to data warehouse? TCS3
What is batch processing in Business Objects?  2
what is main functional differences between BO and COGNOs? TCS4
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.  9
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION? AG-Technologies1
how to optimize the query perfomance in b.o? TCS1
how did u give developed universe to ur client?  1
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how Keane-India-Ltd2
Pls Explain about the different between 6.5 & Xi R2 IBM1
What is the use of BO SDK?  4
can BO generate reports with out CUBICAL data to repository?  3
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com