DATA WAREHOUSE DESIGN & SCHEMAS • DATA WAREHOUSE CONCEPTS • ETT / ETL • DATA WAREHOUSE SCHEMAS • The EQUITIES Data Model • EQUITIES Logical Data Model • EQUITIES Physical Model • PHYSICAL DESIGN CONSIDERATIONS

CREATING MATERIALIZED VIEWS • ABOUT MATERIALIZED VIEWS • CREATE MATERIALIZED VIEWS • ENABLE QUERY REWRITE • STORAGE & TABLESPACE Clauses • PARALLEL & PARTITION BY Clauses • BUILD Clause • NESTED MATERIALIZED VIEWS

MAINTAINING MATERIALIZED VIEWS • ALTER MATERIALIZED VIEW • DROP MATERIALIZED VIEW • DATA DICTIONARY STORAGE • USING EM

MATERIALIZED VIEW REFRESH • ABOUT MATERIALIZED VIEW REFRESH • REFRESH METHODS • CREATE MATERIALIZED VIEW LOG • ALTER MATERIALIZED VIEW LOG • DROP MATERIALIZED VIEW LOG • REFRESH MODES • ON COMMIT Considerations • PERFORMING REFRESH OPERATIONS • Refreshing With REFRESH_ALL_MVIEWS() • Refreshing With REFRESH() • Refreshing With REFRESH_DEPENDENT() • Using EXPLAIN_MVIEW() • DATA DICTIONARY REFRESH METADATA • USING EM

CONTROLLING THE QUERY REWRITE FACILITY • ENABLING QUERY REWRITE • VIEWING EXECUTION PLANS • Create PLAN_TABLE • Using AUTOTRACE • Using EM • CONTROLLING QUERY REWRITE • NOREWRITE • REWRITE • UTILIZING CONSTRAINTS WITH QUERY REWRITE • ENABLE VALIDATE Constraint Option • ENABLE NOVALIDATE Constraint Option • DISABLE NOVALIDATE Constraint Option • DISABLE VALIDATE Constraint Option • RELY Constraint Option • ENFORCED Level • TRUSTED Level • STALE_TOLERATED Level • QUERY REWRITE INFLUENCES • USING EM FOR "WHAT-IF?" SCENARIOS

DIMENSIONS • WHAT ARE DIMENSIONS? • CREATING & MAINTAINING DIMENSIONS • ALTER DIMENSION • DROP DIMENSION • DIMENSION METADATA & VALIDATION

DIMENSIONAL ANALYSIS OF DATA • DATA SAMPLING • DIMENSION AGGREGATION TECHNIQUES • The GROUPING() Function • Using CUBE() • BUILDING THE DATA WAREHOUSE CUBE • The EQUITIES Cube • GROUPING_ID() Function • CUBE() Vs. GROUPING SETS()

STAR QUERIES & THE OPTIMIZER • WHAT IS A STAR QUERY? • A STAR TRANSFORMATION SCENARIO • ENCOURAGING STAR TRANSFORMATION • STAR TRANSFORMATION HINTS • STAR_TRANSFORMATION Hint

ETL: LOADING FROM EXTERNAL TABLES • ABOUT THE EXTRACTION OPTIONS • USING EXTERNAL TABLES • ORACLE_LOADER ACCESS PARAMETERS • RECORDS Parameter • BADFILE Parameter • LOGFILE Parameter • DISCARDFILE Parameter • LOAD WHEN Parameter • SKIP Parameter • The LOCATION Clause • REJECT LIMIT Clause • FIELDS TERMINATED BY Parameter • MISSING FIELD VALUES Parameter • ORACLE_DATAPUMP ACCESS DRIVER • MAINTAINING EXTERNAL TABLES • USER_EXTERNAL_TABLES • USER_EXTERNAL_LOCATIONS • Using ALTER TABLE

ETL: TRANSFORMATION WITH TABLE FUNCTIONS

ABOUT ORACLE WAREHOUSE BUILDER • OWB & THE DATA WAREHOUSE • OWB CAPABILITIES • OWB ARCHITECTURE • OWB Repository • OMB*Plus

CONFIGURE ORACLE WAREHOUSE BUILDER • REPOSITORY DATABASE CONFIGURATION • MANAGE THE CONTROL CENTER SERVICES • CONFIGURE THE REPOSITORY & WORKSPACE

USING THE DESIGN CENTER & BUILDING THE INFRASTRUCTURE • LAUNCH THE DESIGN CENTER • DEFINING THE INFRASTRUCTURE • DEFINING LOCATIONS • DEFINING CONTROL CENTERS • DESIGN CENTER PREFERENCES

DEFINE MODULES & IMPORT METADATA • DEFINE A PROJECT CONTAINER • DEFINE MODULES • IMPORT METADATA

MAINTAINING THE RELATIONAL MODEL • NAVIGATING THE DATA OBJECT EDITOR • WORKING WITH A DETAIL VIEW • DEFINING A NEW OBJECT • DEPLOYING OBJECTS TO A TARGET DATABASE

DATA QUALITY ASSURANCE & MANAGEMENT • ABOUT DATA ANALYSIS PRINCIPLES • CREATE DATA PROFILES • USE THE DATA PROFILE EDITOR

DATA RULES & CORRECTION MAPPINGS • CREATING DATA RULES • APPLYING DATA RULES • CORRECTION MAPPINGS • DATA AUDITING MONITORS

ETL MAPPINGS • USING THE MAPPING EDITOR • ABOUT THE OPERATORS • WORKING WITH STAGING TABLES

PROCESS FLOWS & SCHEDULES • USING PROCESS FLOWS • USING SCHEDULES