OR153

NEW! Data Integration and ETL with Oracle Warehouse Builder: Part 2

This 2-day hands-on course introduces students to the array of options that extend the functionality of OWB.

Students learn the extended ETL and data integration functionality available in the Enterprise ETL/ODI EE option.

Learn to:
  • Use Warehouse Builder to define both relational dimensional models and multidimensional models.
  • Deploy a single logical model to multiple physical targets using multiple named configurations.
  • Handle slowly changing dimensions.
  • Extract data from non-Oracle sources using code templates.
  • Use the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database.

Målgrupp:

  • Datalageranalytiker
  • Datalageradministratör

Du får lära dig:

  • Define relational dimensional and multidimensional models
  • Deploy a logical model to multiple physical configurations
  • Create and manage a type 2 slowly changing dimension
  • Use code templates in mappings to extract data from non-Oracle sources
  • Utilize the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database
  • Create near-realtime and trickle-feed mappings

Innehåll:

Administrative Tasks in Warehouse Builder

  • Enterprise ETL License Extends Core In-Database ETL
  • Multiple Named Configurations: Why and How
  • Using Multiple Named Configurations
  • Using Configuration Templates
  • Steps for Setting Up OWB in a RAC Environment
  • Creating an OWB Schedule

Managing Metadata

  • Using Lineage and Impact Analysis Diagrams
  • Invoking Lineage and Impact Analysis
  • Using the Change Propagation Dialog
  • User-Defined Properties, Icons, and Objects
  • Using Pluggable Mappings
  • Advanced Activity Types in Process Flows
  • Native Relational Object Support
  • Heterogeneous Predefined SQL Transformations

Accessing Non-Oracle Sources

  • Extensible Framework of OWB 11g Release 2
  • Benefits of Extensible Code Templates
  • Location of Seeded Code Templates
  • Creating New Code Templates
  • Defining New Integration Platforms in OWB

Designing Mappings with the Oracle Data Integration Enterprise Edition License

  • Traditional Versus Code Template (CT) Mappings
  • Execution Units in a CT Mapping
  • Execution View Versus Logical View
  • Assigning a Code Template to an Execution Unit
  • Convert a Classic Mapping to a CT Mapping That Utilizes Data Pump
  • CT Mappings Deploy to Control Center Agents

Right-Time Data Warehousing with OWB

  • What Is Meant by Real-Time Data Warehousing
  • What Refresh Frequency Does OWB Support
  • Building a Trickle Feed Mapping
  • Using Advanced Queues in Trickle Feed Mappings
  • Using CDC Code Templates in Mappings for Change Data Capture
  • Starting CDC Capture Process

Defining Relational Models

  • Defining Dimensions Using Wizards and Editors
  • Defining Dimension Attributes, Levels, and Hierarchies
  • Binding Dimension Attributes to the Implementation Table
  • Using the Create Time Dimension Wizard
  • Defining a Cube
  • Specifying a Cube's Attributes and Measures
  • Designing Mappings Using Relational Dimensions and Cubes

More Relational Dimensional Modeling

  • Initial Versus Incremental Data Warehouse Loads
  • Updating Data and Metadata
  • Capturing Changed Data for Refresh
  • Setting Loading Properties
  • Choosing the DML Load Type
  • How OWB Manages Orphans
  • Support for Cube-Organized Materialized Views
  • Creating a Type 2 Slowly Changing Dimension

Modeling Multidimensional OLAP Dimensions and Cubes

  • What Is OLAP
  • Multidimensional Data Types
  • Analytic Workspace
  • Dimensional Modeling Using OWB
  • OWB Calculated Measures
  • Differences Between OLAP and Relational Loading

Appendix: Configuring Warehouse Builder in RAC Environments

  • Oracle Real Application Clusters (RAC)
  • Control Center Service Failover on RAC
  • Installing OWB on Real Application Clusters
  • Useful Diagnostics for OWB RAC Problems

Appendix: Service-Oriented Architectures

  • What Are Services
  • Publishing a Web Service
  • Methods for Creating a Mapping That Uses Web Services
  • Consuming a Web Service
  • Accessing Web Services Securely

Appendix: Importing COBOL Copybooks

  • Flexible File Import Options in OWB 11g Release 2
  • Enhanced Support for COBOL Copybook Import
  • Selecting Copybooks to Import
  • Examine Advanced Import Session Options

Avtalsrabatter eller andra erbjudanden så som t ex Training Cards kan ej nyttjas i samband med bokning av denna utbildning.

Fakta

Kurs
OR153
Längd
2 dagar
Pris
11.400 kr (exkl. moms)
Bookmark and Share

Förkunskaper

OTN Oracle By Example (OBE): Oracle Business Intelligence Warehouse Builder Oracle University ILT: Oracle Database 11g: Data Warehousing Fundamentals

Kursmaterial

Kursmaterial på engelska ingår.

I samarbete med:

Kontakta oss
för mer information:

08 - 587 116 10 (Stockholm)
031 - 773 07 90 (Göteborg)
040-662 20 60 (Malmö)
info@informator.se

 
Gold Partner
Novell Partner