• phone icon +44 7836 212635 email message icon info@uplatz.com
  • Register
Job Meter = 10

Data Integration with Oracle Warehouse Builder

40 Hours
Online 1:1 Instructor-led Training
USD 1400
Data Integration with Oracle Warehouse Builder online course and certification
99 Learners

About this Course
Learn concepts of Oracle Warehouse Builder 11g.
This training starts you at the beginner level and concludes with knowledge of advanced concepts and end-to-end implementation of data integration and ETL through Oracle Warehouse Builder.

Data Integration with Oracle Warehouse Builder

Course Details & Curriculum

Installing and Setting Up the Warehouse Builder Environment

  • Oracle Warehouse Builder Licensing and Connectivity Options
  • Supported operating systems (OS), sources, targets, and optional components
  • What Is Oracle Warehouse Builder?
  • Using the Repository Assistant to Manage Workspaces
  • OWBSYS Schema
  • Using OWB 11.2 with Database 10g R2
  • Installing Oracle Warehouse Builder 11.2
  • Basic Process Flow of Design and Deployment

Getting Started with Warehouse Builder

  • Locations Navigator and Global Navigator panels
  • Logging In to OWB Design Center
  • Overview of Objects within a Project
  • Setting Projects Preferences: Recent Logons
  • OWB Projects
  • Overview of the Design Center
  • Organizing Metadata Using Foldering
  • Overview of Objects within an Oracle Module

Understanding the Warehouse Builder Architecture

  • Overview of Configurations, Control Centers, and Locations
  • Warehouse Builder Development Cycle
  • Registering an Oracle Workflow User
  • Registering DB User as an OWB User
  • Roles and Privileges of Warehouse Builder Users
  • Creating Target Schemas
  • Overview of the Architecture for Design, Deployment, Execution

Defining Source Metadata

  • Difference Between Obtaining Relational and Flat File Source Metadata
  • Data warehouse implementation: Typical steps
  • Creating an Oracle Module
  • Sampling Simple Delimited File
  • Creating Flat File Module
  • Sampling Multi-record Flat File
  • Selecting the Tables for Import

Defining ETL Mappings for Staging Data

  • Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting
  • Creating External Tables
  • Purpose of a Staging Area
  • Set loading type and target load ordering
  • Define OWB Mappings
  • Levels of Synchronizing Changes
  • Using the Automapper in the Mapping Editor
  • Create and Bind process

Using the Data Transformation Operators

  • Lookup Operator: Handling Multiple Match Rows
  • Component Palette
  • Using the Aggregator, Constant, Transformation, and Pre/Post Mapping Operators
  • Pivot and Unpivot Operators
  • Using the Set, Sequence, and Splitter Operators
  • Using the Subquery Filter Operator
  • Using a Joiner
  • Deploying and Executing in Projects Navigator Panel

Cleansing and Match-Merging Name and Address Data

  • Name and Address Data Cleansing
  • Using the Match Merge Operator in a Mapping
  • Name and Address Software Providers
  • Reviewing a Name and Address Mapping
  • Settings in the Name and Address Operator
  • Consolidating Data Using the Match Merge Operator
  • Name and Address Server
  • Integrating Data Quality into ETL

Using Process Flows

  • Types of Activities: Fork, And, Mapping, End Activity
  • Creating Transitions Between Activities
  • Some More Activities: Manual, SQLPLUS, Email
  • Process Flow Concepts
  • Creating a Process Flow Module, a Process Flow Package and a Process Flow
  • Generating the Process Flow Package

Deploying and Reporting on ETL Jobs

  • Deployment Concepts
  • Repository Browser
  • Starting OWB Browser Listener and the Repository Browser
  • Browsing Design Center and Control Center Reports
  • Setting Object Configuration
  • Logical Versus Physical Implementation
  • Invoking the Control Center Manager
  • Deploy Options and Preferences

Using the Mapping Debugger

  • Preparing the testing environment and test data
  • Overview of the Mapping Debugger
  • Initializing a Mapping Debugging Session
  • Evaluating the flow of data to detect mapping errors
  • Setting breakpoints and watch points

Enhancing ETL Performance

  • Performance-Related Parameters in ETL Design
  • Configuring Indexes, Partitions, Constraints
  • Setting Tablespace Properties and Gathering Schema Statistics
  • Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels
  • Enabling Partition Exchange Loading (PEL) for Targets
  • Enabling Parallelism and Parallel DML
  • Performance-Related Parameters in Schema Design
  • Performance Tuning at Various Levels

Managing Backups, Development Changes, and Security

  • Overview of Metadata Loader Utilities (MDL)
  • Graphical UI for Security Management
  • Managing Metadata Changes by Using Snapshots
  • Object-Level Security
  • Using Change Manager
  • Version Management of Design Objects
  • Setting Security Parameters

Integrating with Oracle Business Intelligence Enterprise Edition (OBI EE)

  • Converting the UDML File for OBI EE
  • Oracle BI Admin and Answers Tool
  • Integrating with OBI EE and OBI SE
  • Business Justification: Tools Integration
  • Deploying the BI Module
  • Transferring BI Metadata to OBI EE Server
  • Setting Up the UDML File Location
  • Deriving the BI Metadata (OBI EE)

Administrative Tasks in Warehouse Builder

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

Managing Metadata

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

Accessing Non-Oracle Sources

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

Designing Mappings with the Oracle Data Integration Enterprise Edition License

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

Right-Time Data Warehousing with OWB

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

Defining Relational Models

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

More Relational Dimensional Modeling

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

Modeling Multidimensional OLAP Dimensions and Cubes

  • Dimensional Modeling Using OWB
  • Multidimensional Data Types
  • What Is OLAP
  • OWB Calculated Measures
  • Analytic Workspace

Didn't find what you are looking for?  Contact Us