Základní info
Description
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.
Objectives
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
