Which one of the following OLAP construct can be designed in OWB
-
Materialized Views
-
Tables and Views
-
Facts and Dimesions
-
Logical database objects
C
Correct answer
Explanation
In Oracle Warehouse Builder (OWB), OLAP (Online Analytical Processing) constructs are represented by dimensional objects. OWB allows developers to design Facts and Dimensions, which form the star or snowflake schemas crucial for OLAP cubes.