Gerelateerde onderwerpen:
Oracle | 10g


Oracle Warehouse Builder 10g: Implementation Part I

Doelgroep | Voorkennis | Doel | Onderwerpen | Data & prijzen | Aanmelden
Deze PlusPartner cursus hebben we niet meer in ons assortiment maar nog wel andere cursussen, bijvoorbeeld:Meer informatie? Klik hier!

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 warehouseCreate Data ProfileGenerate Data Rules and Run Correction MappingsDefine source-to-target mappings Design the target warehouseCreate Process FlowsNote: The current version of this course is presented using OWB 10gR2, however this course is also suitable for OWB 11gR1 customers. The user interface differences between OWB 10gR2 and 11gR1 are very minor and hence are not included in this course′s lab practices.A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Doelgroep cursus Oracle Warehouse Builder 10g: Implementation Part I

Business Analysts

Voorkennis

Wij adviseren onderstaande voorkennis:

  • Oracle10g: Data Warehousing Fundamentals course, or prior DW experience or thorough familiarity with DW concepts

Doel

  • Create Data Profile

Onderwerpen cursus Oracle Warehouse Builder 10g: Implementation Part I

De cursus Oracle Warehouse Builder 10g: Implementation Part I behandelt de volgende onderwerpen:

    • 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

    Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?


Vraag informatie aan



Gedetailleerde onderwerpenlijst cursus Oracle Warehouse Builder 10g: Implementation Part I

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Oracle Warehouse Builder 10g: Implementation Part I behandeld zullen worden:

    • 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

Getoonde informatie onder voorbehoud, genoemde prijzen zijn exclusief BTW.

Share |

 
Informatie 
  Contact
  Cursusoverzicht
  Cursuskalender
  Bel mij!
  Brochure aanvragen
  Aanmelden voor nieuwsbrief
  Stel een vraag
 
 
Cursuscategorieën