Extracting, transforming, and loading data into the staging tables and an enterprise model warehouse
Create Data Profile
Generate Data Rules and Run Correction Mappings
Define source-to-target mappings
Designing the target warehouse
Create Process Flows
Create Schedules
Use the Dependency Manager to manage metadata
Deploy objects directly into Oracle Business Intelligence Discoverer EUL |
In this 3-day hands-on course, students learn how to implement a data warehousing solution using Oracle Warehouse Builder (OWB). The concepts, design issues, architecture, and terminology that underlie OWB are explored. Students use OWB client tools to create and maintain OWB design metadata, including source and warehouse target definitions, and ETL mappings to extract, transform, and load data into the targets. Students generate, deploy, and execute OWB design objects to create and populate a target warehouse.
This course focuses on relational dimensional modeling. This course serves as the prerequisite for Oracle Warehouse Builder 10g: Implementation Part 2. That course focuses on MOLAP modeling, and advanced features of OWB.
|
SETTING UP AND STARTING WAREHOUSE BUILDER
• Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup
• Describe Oracle Warehouse Builder program group components
• Log in to the Design Center
• Create a design repository and users
• Open a project and navigate the user interface
INTRODUCING OWB 10G R2 ARCHITECTURE AND CONFIGURATION
• Describe the Warehouse Builder repository architecture, users, and owners
DEFINING SOURCE METADATA
ENSURING DATA QUALITY USING DATA PROFILING
DEFINING STAGING METADATA AND MAPPING TABLES
DERIVING DATA RULES AND RUNNING CORRECTION MAPPINGS
DEFINING A RELATIONAL DIMENSIONAL MODEL
HANDLING SLOWLY CHANGING DIMENSIONS
USING PROCESS FLOWS
DEPLOYING, LOADING, AND VIEWING DATA
BUSINESS INTELLIGENCE INTEGRATION
|
