• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

Data Integration with Oracle Warehouse Builder

40 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Dec-2023
Data Integration with Oracle Warehouse Builder course and certification
99 Learners

About this Course

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.

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.

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


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
Career Path

The Oracle certified warehouse developer certification course with the help of expert professionals training is recognized across the globe. Because of the increased adoption of the data integration and transformation in various companies the participants are able to find the job opportunity easily. The leading companies hire Oracle warehouse builder considering their skill of mastering OWB tool and perform data audit, transformation for better quality.  The Oracle warehouse builder can pursue a wide range of career paths.

The following are the job titles:

  • Datastage developer

  • Supply chain head

  • Audit consultant

  • Database architect

  • Design engineer professional




Job Prospects

The Oracle warehouse developer draws an average salary of $74, 058 per year depending on the knowledge and hands-on experience. The Oracle warehouse developer job roles are in high demand and make a rewarding career.


Interview Questions

1. Define oracle warehouse builder?

Oracle warehouse builder refers to ETL tool offered by Oracle that provides a graphical environment to create, maintain and manage data integration process in business intelligence systems.

2.Mention the new features of oracle OWE-EE 11gR2?

The new features of oracles OWE-EE 11gR2 comprises

  • Code template mappings using ODI knowledge modules

  • Native heterogeneous connectivity

  • Charged data capture mappings

  • Advanced queue support in mappings

  • SOA integration publishing and consuming web services

3. Mention the enhancements made in OWB 11gR2?

In OWB 11gR2 enhancements made comprises

  • Improved support for watch points

  • Disabling and enabling of individual break points

  • Support for user-defined type columns

  • Improved support for numerous operators such as Array, Expand and Construct

  • Support for table function operators and key lookup

  • Support for correlated joints

  • Enhanced cleanup of debugger specific objects

4. Mention the important components of Oracle warehouse builder?

The oracle warehouse builder comprises two section Client side and Server side

Client side: Design Center and Repository browser

Server side: Control center service, Workspace, Warehouse Builder Repository and Target Schema (Oracle database)

5. What is the general procedure for importing Metadata from sources?

To import meta-data from sources:

  • Review the list of supported targets and sources

  • Choose a location for imported data

  • Create a module for the source meta-data as described in “creating modules”

  • Right click the module and select import

Follow the instruction in the import data wizard

For oracle data objects, view the data saved in the data object using the data viewer. Right click the object and select Data


6. Mention the types of locations you can deploy data in OWB?

You can deploy data to different types of locations like

Databases: suitable for relational business intelligence systems, which includes objects such as views and tables, or cubes and dimensions

Files: suitable for storing data in XML format or in comma-delimited

Applications: suitable for SAP systems

Process flows and schedules: Targets for managing ETL

Business Intelligence: suitable for meta-data derived from oracle modules or databases

7. Brief how you can design objects in the project in Oracle Warehouse Builder?

The PROJECTS are the largest storage object inside warehouse builder.  You need to include all the objects in a project that you can share information.  This comprises data objects, mappings and transformation operations.

8. How to delete a project in OWB?

To delete a project in OWB there are some restriction since projects are the primary design components. 

To delete a project:

  • Break down the project you want to delete

  • Choose and elaborate any other project

  • Track the project you want to delete and from the Edit menu, select DELETE or right click and select delete

  • Click OK to delete the project

9. Mention the meta-data security strategies in OWB?

The Security strategies in OWB comprises:

  • Minimal Meta-data Security Strategy

  • Multi-user Security Strategy

  • Full Meta-data Security Strategy

10. What does target schema consist of in OWB?

Target schema consists of

  • Generated Code

  • Cubes

  • Dimensions

  • Tables

  • Views

  • Mapping

  • Packages to execute ETL processes

11. Mention how connectors function in OWB?

A connector is a logical link created by a mapping between the target location and a source location.  The connector between schemas in two different oracle databases is executed as a database link, and the connector between a schema and an operating system directory is executed as a database directory.  

12. Define modules in OWB?

Modules are  known as grouping activity in the project explorer that interacts to locations in the connection explorer.  A single location can address to multiple modules.  



Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

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