Business Intelligence Interview Question and Answers

13. What is join?
  • 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.
  • The join is specified in the Where clause of the sql statement.
The different types of joins are
  • Equi join - is based on the equality between the values in the column. Because the same column is present in both tables, the join synchronizes the two tables.
  • Outer join - An outer join links two tables, one of which has rows that do not match those in the common column of the other table.
  • Theta join - A theta join links tables based on a relationship other than equality between two columns.
  • Shortcut join - Shortcut joins can be used in schemas containing redundant join paths leading to the same result, regardless of direction.
Your Name Your Email-ID
Your Answer
14. What is a data provider?
  The data source (Query) is called as the data provider.
Your Name Your Email-ID
Your Answer
15. Did you do metadata reporting in BO?
  • Metadata reporting of BO is possible. BO provides a separate universe which actually contains repository tables, objects etc.
  • Using this Universe one can do metadata reporting in BO.
Your Name Your Email-ID
Your Answer
16. What are the ways by which u can distribute the universe?
  There are two ways to distribute a universe: through the repository or through the file system.
Your Name Your Email-ID
Your Answer

131415 Page 4 of 15