Oracle BI Applications 11g Implementation using ODI/b

This Oracle BI Applications: Implementation Using ODI training provides step-by-step procedures for installing, configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. It begins by exploring Oracle BI Applications components and architecture.

Retail Price: $3,465.00

Next Date: Request Date

Course Days: 3


Request a Date

Request Custom Course


Learn To:

  • Identify and describe the products, architecture and key components of Oracle Business Intelligence Applications.
  • Use Configuration Manager and Functional Setup Manager to configure Oracle BI Applications.
  • Identify and describe the security features of Oracle Business Intelligence Applications.
  • Manage the performance of Oracle Business Intelligence Applications and Oracle Business Analytics Warehouse.

 

Skills Gained

  • Identify and describe the extract
  • transform
  • and load (ETL) concepts
  • products
  • components
  • and processes related to Oracle Business Intelligence Applications
  • Identify and describe the products
  • architecture
  • and key components of Oracle Business Intelligence Applications
  • Identify and describe the content of Oracle Business Analytics Warehouse
  • Install and set up Oracle Business Intelligence Applications and supporting technology
  • Identify and describe the prebuilt Oracle Data Integrator ETL metadata for Oracle Business Intelligence Applications
  • Use Configuration Manager and Functional Setup Manager to configure Oracle BI Applications
  • Use Configuration Manager to create
  • generate
  • execute
  • and monitor load plans
  • Describe the concepts and techniques for customizing ETL functionality in Oracle Business Intelligence Applications
  • Use Oracle Data Integrator Studio to customize ETL metadata objects and the Oracle Business Intelligence Warehouse
  • Identify and describe the security features of Oracle Business Intelligence Applications

 

Who Can Benefit

  • Administrator
  • Architect
  • Developer

 

Prerequisites

  • Experience in Business Intelligence
  • Knowledge of Data warehouse design
  • Knowledge of Dimensional modeling
  • Knowledge of ETL

Course Outline

Oracle Business Intelligence Applications Overview

  • Oracle BI Applications components
  • Business areas supported in Oracle BI Applications

Oracle BI Applications Architecture

  • Oracle BI Applications components overview
  • Oracle BI Applications architecture overview
  • Oracle BI Applications product lifecycle overview

Oracle Business Analytics Warehouse Content

  • Pre-built star schemas in Oracle Business Analytics Warehouse
  • Oracle Business Analytics Warehouse naming conventions
  • Overview of Oracle Business Analytics Warehouse tables
  • System columns in Oracle Business Analytics Warehouse tables

Installing Oracle Business Intelligence Applications

  • Preinstallation and deployment requirements
  • Installing Oracle BI Applications prerequisites
  • Installing Oracle BI Applications
  • Performing post-installation system set up tasks

Understanding the ETL Process

  • ETL phases and processing overview
  • Using ODI Studio to explore prebuilt ETL metadata
  • Full ETL and incremental ETL
  • Change capture
  • ETL versus ELT

Functional Configuration for Oracle BI Applications

  • Functional configuration overview
  • Terminology related to Oracle BI Applications configuration
  • Configuration Manager overview
  • Functional Setup Manager overview
  • Creating an implementation project
  • Assigning configuration tasks to developers

Administering and Maintaining Functional Configuration Data

  • Functional configuration data overview
  • Administering and maintaining domains and domain mappings
  • Editing domain members
  • Administering and maintaining data load parameters
  • Administering and maintaining reporting parameters

Managing Load Plans

  • Defining, generating, executing, and monitoring load plans
  • Troubleshooting and restarting load plans
  • Managing load plan parameters

Customizing the Oracle Business Analytics Warehouse

  • Customization types and scenarios overview
  • Overview of category1 and category 2 customizations
  • Impact of patches on customizations
  • Applying an update strategy

Building a Category 1 Customization

  • Adding columns to existing tables in the OBAW
  • Creating custom ETL mappings for a category 1 customization
  • Enabling versioning for a category 1 customization
  • Generating DDL scripts for a category 1 customization
  • Creating and executing a load plan for a category 1 customization

Building a Category 2 Customization

  • Adding a new dimension table to the OBAW
  • Creating custom ETL mappings for a category 2 customization
  • Enabling versioning for a category 2 customization
  • Generating DDL scripts for a category 2 customization
  • Creating and executing a load plan for a category 2 customization

Oracle BI Applications Security

  • Tools used to manage Oracle BI Applications security
  • Oracle BI Applications security levels
  • Exploring default security settings for Oracle BI Applications
  • Exploring ODI security

Managing Performance

  • Optimizing performance overview
  • Performance tuning recommendations


Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date