11g ocm考试大纲电子.pdfVIP

Objectives After completing this lesson, you should be able to do the following: • Describe the need for dimensions • Create dimensions • View dimension definition information • Validate dimension data and maintain dimensions Lesson Agenda • Describe the need for dimensions • Create dimensions • View dimension definition information • Validate dimension data and maintain dimensions What Are Dimensions? A dimension is a structure that categorizes data to enable users to answer business questions. What is the effect of promoting one product on the sale of a related product that is not What are the sales promoted? of a product before and af promotion? How does a promotion affect the various distribution channels? What Are Dimension Objects? • Data dictionary structures that define hierarchies between pairs of column sets • Used with materialized views for query rewrite • Superset of referential constraints: – Normalized dimensions: Each child-side row joins with only one parent-side row. – Denormalized dimensions: Child-side columns uniquely determ he parent-side columns. • Never en d, but can be validated • Enable additional query rewrites without the use of constraints Benefits of Using Dimensions • If your application uses dimensional modeling, create dimensions because they help query rewrite perform more complex types of rewrite. • Dimensi