Oracle Warehouse Builder 11g

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Oracle Warehouse Builder 11g which gives you the opportunity to interact with a Oracle Warehouse Builder 11g instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


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

Additional features of Oracle Warehouse Builder

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234