Course Outline

Course Outline

Oracle Business Intelligence Application: Overview

  • Exploring Oracle Business Intelligence (BI) Applications
  • Exploring the key components of Oracle BI Applications
  • Exploring Oracle BI Applications integration with transactional applications

Oracle Business Intelligence Applications Architecture: Overview

  • Exploring the Oracle BI Applications logical architecture
  • Exploring the process flow of building the data warehouse
  • Employing the recommended deployment options to maximize data warehouse performance
  • Exploring the core components supporting the OBAW and the functions performed by each core component

Oracle Business Analytics Warehouse Content

  • Exploring the content of the OBAW
  • Exploring OBAW tables

Installing Oracle Business Intelligence Applications

  • Identifying the installation prerequisites
  • Configuring the Data Warehouse Administration Console (DAC)
  • Configuring Informatica Workflow Manager

Understanding the ETL Process

  • Exploring the extract, transform, and load (ETL) process used to load the OBAW
  • Identifying the differences between a full load and an incremental load of the OBAW
  • Identifying the applications and mechanisms used to support the ETL process

Working with Informatica Designer

  • Identifying the Informatica repository objects used to configure the OBAW
  • Navigating the set of tools in Informatica Designer used to configure Informatica repository objects

Working with Informatica Workflow Manager

  • Navigating Informatica Workflow Manager
  • Running workflows and sessions using Informatica Workflow Manager
  • Monitoring workflows using Informatica Workflow Monitor

Exploring SDE and SIL Mappings

  • Describing the differences between Source-Dependent Extract (SDE) and Source-Independent Load (SIL) mappings
  • Identifying typical objects and their mechanics in SDE and SIL mappings

Working with the Data Warehouse Administration Console

  • Using the tools and views of the DAC
  • Describing DAC objects, how they relate to each other, and their roles in the OBAW ETL process

Configuring Analytical Applications

  • Performing preload configuration steps that apply to Oracle Business Intelligence Applications deployed with any source system

Customizing DAC Metadata and Running an Execution Plan

  • Creating custom metadata objects in the DAC
  • Running a DAC execution plan and monitoring the results

Customizing Oracle Business Analytics Warehouse

  • Identifying and describing customization categories and scenarios associated with OBAW
  • Applying OBAW customization best practices

Adding Columns to an Existing Dimension Table

  • Completing the steps in a Category 1 customization of the OBAW
  • Adding a column to an existing dimension table in the OBAW and populating it with data

Adding a New Dimension in OBAW

  • Completing the steps in a Category 2 customization of the OBAW
  • Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse

Integrating Security for Oracle Business Intelligence Applications

  • Exploring the types of security in Oracle BI Applications
  • Describing how Oracle BI integrates with the Oracle Fusion Middleware security platform
  • Identifying how BI Application object and data security integrate with Siebel responsiblities

Exploring the Change Capture Process

  • Describing the change capture process
  • Exploring and generating change capture tables and views

Capturing and Applying Deletes

  • Generating and executing delete triggers
  • Building mappings to capture and apply deletes

Managing OBAW Performance

  • Exploring strategies for increasing ETL and query performance
  • Identifying common performance bottlenecks
  • Configuring servers to optimize ETL and query performance

Scheduled Dates

  • Location
    Cost
    Duration
    Start Date
     
Virtual Class
  • Virtual Class
    3320
    4
    02 Dec 14
  • Virtual Class
    4120
    4
    02 Dec 14
  • TBA
    0
    4
    29 Dec 14
  • Virtual Class
    3320
    4
    03 Feb 15
  • Virtual Class
    4120
    4
    03 Feb 15
  • Virtual Class
    3320
    4
    16 Feb 15
  • Virtual Class
    4120
    4
    16 Feb 15
  • Virtual Class
    3320
    4
    31 Mar 15
  • Virtual Class
    4120
    4
    31 Mar 15
  • Virtual Class
    3320
    4
    19 May 15
  • Virtual Class
    4120
    4
    19 May 15
  • London (Central)
    • TBA
      0
      4
      02 Feb 15
    • Manchester (Greater)
      • TBA
        0
        4
        23 Feb 15
      • Berkshire
        • TBA
          0
          4
          23 Feb 15
        • Midlands (West)
          • TBA
            0
            4
            23 Mar 15
          • Onsite
            • Onsite
              0
              4
              Onsite

Quick Links