Oracle Warehouse Builder 10g: Implementation Part I

Seminar

In Braunschweig, Düsseldorf, Gummersbach und 1 weiterer Standort

1.770 € zzgl. MwSt.

Beschreibung

  • Kursart

    Seminar

  • Niveau

    Anfänger

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 da.. Gerichtet an: Businessanalytiker, Data Warehouse-Administratoren, Data Warehouse-Analytiker, Datenbankadministratoren

Standorte und Zeitplan

Lage

Beginn

Braunschweig (Niedersachsen)

Beginn

auf Anfrage
Düsseldorf (Nordrhein-Westfalen, NRW)

Beginn

auf Anfrage
Gummersbach (Nordrhein-Westfalen, NRW)

Beginn

auf Anfrage
München (Bayern)

Beginn

auf Anfrage

Hinweise zu diesem Kurs

- "Oracle10g: Data Warehousing Fundamentals" course, or prior DW experience or thorough familiarity with DW concepts - Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

Empfohlene Vorkenntnisse:
"Oracle By Example: Warehouse Builder 10g R2: Getting Started "eStudy: Introduction to Business Intelligence Products

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Inhalte

Seminarziel

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

Zielgruppe

Businessanalytiker, Data Warehouse-Administratoren, Data Warehouse-Analytiker, Datenbankadministratoren

Seminarinhalte

- 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
Sachgebiete:

Setting Up and Starting Warehouse Builder
"Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup "Describe Oracle Warehouse Builder program group components "Log in to the Design Center "Create a design repository and users "Open a project and navigate the user interface Introducing OWB 10g R2 Architecture and Configuration
"Discuss various design and run-time configurations "Describe the Warehouse Builder repository architecture, users, and owners "Describe the OWB repository architecture, users, and owners "Explain the benefits of warehouse staging areas "Describe the course data sources and targets "Import metadata using tcl scripts Defining Source Metadata
"Define and create source modules "Specify source data from flat files "Specify source data from relational database tables "Import source object metadata into the source modules Ensuring Data Quality Using Data Profiling
"Create a data profile "Profile the data "View profile results "Analyze profile results Defining Staging Metadata and Mapping Tables
"Create a target module "Add a staging table to a staging area warehouse module "Define mappings between source objects and staging table columns Deriving Data Rules and Running Correction Mappings
"Derive data rules "Create a correction "Run the generated correction mappings Defining a Relational Dimensional Model
"Define dimensions and cubes "Navigate the Data Object Editor "Define ETL mappings to load the dimensions and cubes Handling Slowly Changing Dimensions
"Explain how OWB handles a slowly changing dimension "Define a type 2 slowly changing dimension "Use the type 2 policy dialog box Using Process Flows
"Navigate the process flow editor "Create process flow definitions "Define a schedule "Use process flow activity templates "Use process flow activities Deploying, Loading, and Viewing Data
"Use the Control Center Manager "Load data into tables "Use the Dependency Manager to manage metadata Business Intelligence Integration
"Define Oracle Discoverer structures "Derive Oracle Discoverer structures "Define cross-tab and graph presentation templates

Voraussetzungen

- "Oracle10g: Data Warehousing Fundamentals" course, or prior DW experience or thorough familiarity with DW concepts - Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

Empfohlene Vorkenntnisse:
"Oracle By Example: Warehouse Builder 10g R2: Getting Started "eStudy: Introduction to Business Intelligence Products
Hinweis

Empfohlene weitere Ausbildung:- "Oracle Warehouse Builder 10g: Implementation Part II"

Oracle Warehouse Builder 10g: Implementation Part I

1.770 € zzgl. MwSt.