Oracle warehouse builder refers to comprehensive tool for all sort of data integration concepts. The Oracle warehouse builder online course intention is to elevate data into quality information.

Course Objective

The Oracle warehouse builder training is intended for the individuals who seek to implement their knowledge, skills and expand their career as Oracle warehouse builder. The dedicated mentors make sure the learners to cover all topics under Oracle warehouse builder curriculum which will be useful for their career growth. Uplatz offers Oracle warehouse builder tool training to become a skilled Oracle warehouse builder job.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Course Description

Oracle warehouse builder course program will let the participants gain complete proficiency to learn the enterprise solutions for complete data integration.

The Oracle warehouse builder course is ideally developed for developers who can deploy various  forms of data integration strategies. 

In the Oracle warehouse builder course, Uplatz provides an in-depth training for the participants or learners to make them understand the experience of developing core skills to gear up with the OWB tool. 

The Oracle warehouse builder tool is to offer graphical platform to build, manage and maintain data integration process in business intelligent systems.

With the help of Oracle Warehouse builder online course, the learners can:

• Access wide range of data sources

• Able to perform, cleanse and transform data 

• Able to implement design for various applications

• Perform audit trails

• Perform several methods to transform data

Uplatz provides an in-depth training to the learners to accelerate their knowledge and skill set required for Oracle warehouse builder.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Target Audience

The Oracle warehouse builder course is intended for the below mentioned target audience, still if you are a newbie and want to make a career as an Oracle warehouse builder then the Oracle warehouse builder course is the best option you can choose.

• Developers

• Administrators

• Oracle Professionals

• End user
  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------

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