Course Content
Introducing OWB 10g R2 Architecture and Configuration
- Discuss various design and run-time configurations
- Describe the Warehouse Builder repository architecture, users, and owners
- Describe the OWB repository architecture, users, and owners
- Explain the benefits of warehouse staging areas
- Describe the course data sources and targets
- Import metadata using tcl scripts
Defining Source Metadata
- Define and create source modules
- Specify source data from flat files
- Specify source data from relational database tables
- Import source object metadata into the source modules
Ensuring Data Quality Using Data Profiling
- Create a data profile
- Profile the data
- View profile results
- Analyze profile results
Defining Staging Metadata and Mapping Tables
- Create a target module
- Add a staging table to a staging area warehouse module
- Define mappings between source objects and staging table columns
Deriving Data Rules and Running Correction Mappings
- Derive data rules
- Create a correction
- Run the generated correction mappings
Defining a Relational Dimensional Model
- Define dimensions and cubes
- Navigate the Data Object Editor
- Define ETL mappings to load the dimensions and cubes
Handling Slowly Changing Dimensions
- Explain how OWB handles a slowly changing dimension
- Define a type 2 slowly changing dimension
- Use the type 2 policy dialog box
Using Process Flows
- Navigate the process flow editor
- Create process flow definitions
- Define a schedule
- Use process flow activity templates
- Use process flow activities
Deploying, Loading, and Viewing Data
- Use the Control Center Manager
- Load data into tables
- Use the Dependency Manager to manage metadata
Business Intelligence Integration
- Define Oracle Discoverer structures
- Derive Oracle Discoverer structures
- Define cross-tab and graph presentation templates
Additional features of Oracle Warehouse Builder