Oracle Warehouse Builder 10g: Implementation Part I هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

In this 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.

Objectives

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

Course Outline:

• Setting Up and Starting Warehouse Builder
• Introducing OWB 10g R2 Architecture and Configuration
• 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