Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2

Download Course Contents

Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 Course Overview

Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 training course is designed for implementation team members responsible for performing extract, transform and load (ETL) routines from Oracle E-Business Suite (EBS). This course provides step-by-step procedures for installing, designing, customizing and configuring Oracle Business Intelligence (BI) Applications and Oracle Business Intelligence Warehouse (OBAW).
 
Audience:
  • Administrator
  • Analyst
  • Architect
  • Developer
  • Implementer

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Oracle Business Intelligence Applications Overview
  • Exploring Oracle Business Intelligence (BI) Applications
  • Exploring the key components of Oracle BI Applications
  • Exploring Oracle BI Applications integration with transactional applications
  • 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 Oracle Business Analytics Warehouse (OBAW) and the functions performe
  • Exploring the content of the Oracle Business Analytics Warehouse (OBAW)
  • Exploring OBAW tables
  • Identifying the installation prerequisites
  • Configuring DAC
  • Configuring Informatica Workflow Manager
  • Exploring the extract, transform, and load (ETL) process used to load the Oracle Business Analytics Warehouse (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
  • Identifying the Informatica repository objects used to configure the Oracle Business Analytics Warehouse (OBAW)
  • Navigating the set of tools in Informatica Designer used to configure Informatica repository objects
  • Navigating Informatica Workflow Manager
  • Running workflows and sessions using Informatica Workflow Manager
  • Monitoring workflows using Informatica Workflow Monitor
  • 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
  • Using the tools and views of the Data Warehouse Administration Console (DAC)
  • Describing DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBA
  • Performing preload configuration steps that apply to Oracle Business Intelligence Applications deployed with any source
  • Configuring general ledger account hierarchies using general ledger accounting flexfield value set definitions
  • Mapping Oracle general ledger natural accounts to group account numbers
  • Creating a new metric in the repository after adding a new group account number
  • Creating custom metadata objects in the DAC
  • Running a DAC execution plan and monitoring the results
  • Identifying and describing customization types and scenarios associated with OBAW
  • Applying OBAW customization best practices
  • Completing the steps in a Type I customization of the OBAW
  • Adding a column to an existing dimension table in the OBAW and populating it with data
  • Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse
  • Exploring the types of security in Oracle Business Intelligence Applications
  • Describing how Oracle BI integrates with the Oracle Fusion Middleware security platform
  • Identifying how BI Application object and data security integrate with EBS responsiblities
  • Exploring strategies for increasing extract, transform, and load (ETL) and query performance
  • Identifying common performance bottlenecks
  • Configuring servers to optimize ETL and query performance
Live Online Training (Duration : 32 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 32 hours. We can offer you an Ultra-Fast Track for 16 hours

Course Prerequisites
  • Working knowledge of Informatica PowerMart or PowerCenter
  • Basic knowledge of SQL
  • Experience in Business Intelligence
  • Knowledge of Dimensional modeling, and database design

Upon completion of this course; you will be able to:

  • Customize and extend the OBAW
  • Manage the security and performance of Oracle BI Applications
  • Customize DAC metadata
  • Explore Oracle Business Intelligence Applications foundational concepts and architecture
  • Install and configure Oracle BI Applications
  • Explore the prebuilt extract, transform, and load (ETL) metadata for Oracle BI Applications
  • Use the Data Warehouse Administration Console (DAC) to run ETL routines to populate the OBAW
  • Explore Oracle Business Analytics Warehouse (OBAW) foundational concepts and architecture

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner