Multiple choice technology databases

Which one of the following OLAP construct can be designed in OWB

  1. Materialized Views

  2. Tables and Views

  3. Facts and Dimesions

  4. Logical database objects
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle Warehouse Builder is designed for building data warehouses using dimensional modeling principles. The core OLAP construct you design in OWB is the fact and dimension structure - facts contain quantitative measurements while dimensions provide descriptive context. While OWB can work with materialized views and tables, the fundamental OLAP design element is the fact/dimension schema.

Keep practicing — related questions