FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

Business Objects INTERVIEW QUESTION & ANSWERS

Data Warehousing
Follow Us
 
TAGS
91. What are the different schemas supported by BO Designer?
 
  • Star Schema
  • Snowflake Schema
  • Multistar Schema
  • Normalized production Schema
  • Data warehouse with aggregates
Your Name Your Email-ID
Your Answer
 
92. What is a join?
  Join combines columns and data from two or more tables. Join is the relation that occurs between the two tables that helps to combine into one table. The purpose of join is that to restrict the Cartesian product.
Your Name Your Email-ID
Your Answer
 
93. How many types of join are available?
 
    Designer supports the following types of joins :
  • equi joins
  • outer joins
  • theta joins
  • shortcut joins
Your Name Your Email-ID
Your Answer
 
94. What is theta join?
  A join is a relational operation that causes two or more tables with a common domain to be combined into a single table. The purpose of joins is to restrict the result set of a query run against multiple tables.
  Posted by Ane. (May 21, 2013)
 

A theta join is a non-equi join.
Your Name Your Email-ID
Your Answer
 
95. How do you determine that you are working on the latest edition of the Universe?
  Each time you export a universe to a universe domain, DESIGNER increments the revision number of the universe. In this way, you can determine which is the latest version of the universe.
Your Name Your Email-ID
Your Answer