Oracle9i Warehouse Builder: Implementation - Seminare

Seminarziel

Upon completion of this course, participants will be able to implement an enterprise-wide data warehousing solution using Oracle Warehouse Builder (OWB). Participants will explore the concepts, design issues, architecture, and terminology that underlie OWB. Participants will create and maintain OWB Repository and Warehouse databases using OWB client tools.

Zielgruppe

• Data Warehouse Implementer
• Data Warehouse Administrator

Voraussetzungen

• Understanding of data warehouse architecture
• Understanding of data warehouse development methodology

Inhalt

• Approaches to Building a Warehouse
• Case Study - VintnersVine.com
• The Solution - Oracle Warehouse Builder
• Installing and Starting OWB
• Defining Source Metadata
• Defining Staging Area Metadata
• Deploying and Populating Staging Area Objects
• Defining and Populating the Enterprise Model Warehouse
• Defining and Populating Data Marts
• OWB Browser Metadata Reporting
• Incremental Data Loading
• Maintaining the Warehouse and Data Mart Objects
• Migrating and Sharing Metadata
• OWB Bridges
• Warehouse Operations: OEM and Workflow

Literatur

nach Absprache

Verwandte Seminare

 

[ Zurück ]