Category Archives: BO Designer Interview Questions

What Are Loops? | BO Designer Questions

In a relational database, a loop occurs when joins form multiple paths between lookup tables.

Posted in BO Designer Interview Questions | Leave a comment

What Types of Join Paths Return Incorrect Results? | BO Designer Questions

1. Loops (Too few rows) 2. Fan Trap (Too many rows) 3. Chasm Trap (Too many rows)

Posted in BO Designer Interview Questions | Leave a comment

What are Lookup and Fact Tables? | BO Designer Questions

Lookup tables: A lookup (or dimension) table contains information associated with a particular entity or subject. Fact Tables: A fact table contains statistical information about transactions.

Posted in BO Designer Interview Questions | Leave a comment

If there are changes in the database on which you have already created a universe, how do you include those additional changes into your universe? | BO Designer Questions

By refreshing the structure I get the updated database structure.

Posted in BO Designer Interview Questions | Leave a comment

What is Parse checking? | BO Designer Questions

Parse checking means how DESIGNER is to determine the validity of an object, join, or condition. • Quick parsing checks only the syntax of components. • Thorough parsing checks both the syntax and semantics of components.

Posted in BO Designer Interview Questions | Leave a comment

Why do you perform ‘Integrity Check’? | BO Designer Questions

• It detects any errors in the objects, joins, conditions, and cardinalities of your universe. • It detects whether there are any loops in the joins. • It detects whether contexts are necessary. • It determines whether any changes were … Continue reading

Posted in BO Designer Interview Questions | Leave a comment

What is a Cartesian product? | BO Designer Questions

A Cartesian product is the result of a query in which two or more tables are not linked by a join. If executed, the report shows results for each possible combination of each table row.

Posted in BO Designer Interview Questions | Leave a comment

What is Cardinality? | BO Designer Questions

Cardinality expresses the minimum and maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0, 1, or N. … Continue reading

Posted in BO Designer Interview Questions | Leave a comment

What is a join? | BO Designer Questions

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. … Continue reading

Posted in BO Designer Interview Questions | Leave a comment

What is the list mode? | BO Designer Questions

List mode command (View ? List Mode) provides list of all the tables, joins, and contexts.

Posted in BO Designer Interview Questions | Leave a comment