Oracle Warehouse Builder 10g: Implementation Part I

Oracle Warehouse Builder 10g: Implementation Part I

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 additional features of OWB.

Learn To:

• Extract, transform, and load 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 Design the target warehouse
• Create Process Flows

Course Duration – Full Time: The course lasts 5 days.

Course Duration – Part Time: The course lasts 1 month.

REGISTER FOR THIS COURSE