Oracle Warehouse Builder 10g: Implementation [Part 1 Of 2]

Product 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, & terminology that underlie OWB are explored. Students use OWB client tools to create & maintain OWB design metadata, including source & warehouse target definitions, & ETL mappings to extract, transform, & load data into the targets. Students generate, deploy, & execute OWB design objects to create & 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, & additional features of OWB.

Course objectives:

• Create Data Profile
• Generate Data Rules & Run Correction Mappings
• Define source-to-target mappings
• Designing the target warehouse
• Create Process Flows
• Extracting, transforming, & loading data into the staging tables & an enterprise model warehouse
• Create Schedules
• Use the Dependency Manager to manage metadata
• Deploy objects directly into Oracle Business Intelligence Discoverer EUL

This training may be available onsite; please contact us if you are interested.