Oracle BI Applications for E-Business Suite

    

Summary:
Learn and practice step by step procedures for installing, designing, customizing, and configuring Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. The course begins with an exploration of Oracle BI Applications components, Informatica mappings and architecture along with the steps to install and configure Oracle BI Applications, OBAW, and Informatica. Gain an understanding of the ETL process and the relationships between the architecture components by exploring and practice designing the Informatica and DAC components. The practice labs involve running a execution plan to load Oracle E Business Suite data into the OBAW. After the data is loaded, you learn how to customize the OBAW by adding columns to an existing dimension table, and adding a new dimension.

Duration:
4 Days/Lecture & Lab

Audience:
-Application Developers -Data Warehouse Administrators-Data Modelers-OBIEE AdministratorsData Warehouse Developers

Topics:

• Oracle Business Intelligence Applications Architecture Overview
• Installing and Configuring Oracle BI Applications and Related Components
• Working with Informatica Designer
• Working with Informatica Workflow Manager
• Exploring SDE and SIL Mappings
• Working with the Data Warehouse Administration Console
• Customizing DAC Metadata and Running and Execution Plan
• Customizing the Oracle Business Analytics Warehouse
• Adding Columns to an Existing Dimension Table
• Adding a New Dimension in OBAW
• Managing OBAW Performance

Prerequisites:
-Working knowledge of Informatica PowerMart or PowerCenter -Basic knowledge of SQL -Experience in business intelligence -Dimensional modeling, database design -Data Modeling and Relational Database Design

Last Update: May 23, 2012