Oracle BI Apps 7.9.6.x

Who can learn this course:

· Business Analysts

· End Users

· Technical Consultant

· Functional Implementer

· Business Intelligence Developer

· Application Developers

· Developer

· Technical Administrator

Pre Requisite:

  • Basic knowledge on Sql and PLSQL

End Objective:

· Build and use views and graphs in analyses

· Combine analysis criteria using set operations and execute direct database requests

· Perform pre- and post-aggregate filtering using filters, groups, and selections

· Add geographical mapping to analyses

· Use Oracle Business Intelligence Mobile to view BI content on a mobile device

· Create and modify dashboards

· Use Oracle BI for Microsoft Office to integrate Oracle BI analysis and dashboard content

· Configure Agents using Delivers to get the results of analyses and deliver them to subscribers

· Create and modify Oracle Business Intelligence analyses

· Use hierarchical columns in analyses and views

· Perform administration tasks related to the development and configuration of dashboards

Course Duration: 40 Hours

Course Content :

Week 1:

· Overview on ETL Process

· Introduction and Architecture of Informatica

· Installation of Informatica

· Overview on Informatica Client Tool

· Informatica Design Process

· Creating a Simple Mappings and Workflows

· Executing Work flows

· Hands on Exercise

Week 2:

· Follow up on Previous day Training

· Overview on Transformations

· Working with source Qualifier, Expression, Filter, Router,

Sorter, Aggregator, Rank, Union, Joiner, Normalizer, Lookup, Sequence Generator And Update Strategy transformation.

· Working with Flat files

· Hands on Exercise

Week 3:

· Reusable Transformations, Mapplets

· Local variables, parameters and Variables

· Workflows Error Handling

· Using debugger

· Working with Slowly Changing Dimensions

· Working with on Administration Console

· Migration of Informatica Repository

· Installation of OBIEE for supporting BI Apps Installation.

Week 4:

BI Apps Training Process:

· Installing BI Apps

· Restoring Informatica Prebuilt Repository

· Configuring the OOTB Domain files

· Configuring Common areas for all modules and for specific Modules

· Exploring BI Apps Out of the Box mappings with Naming convention

· Go through DMR (Data Modeling Reference) document for the specific Apps Version


· Keywords, Naming Convention and Working Strategy for the Enhancement of OOTB

Mappings And Development of OOTB Mappings for Any module.

Week 5:

DAC Training Process:

· Overview on DAC (Data warehouse Administration Console)

· Architecture and Installation of DAC

· Overview on DAC Client

· Integrating Informatica with DAC

· Creating Oracle Business Analytics warehouse

· Development process in DAC

· Executing Full Load & Incremental Load before Customization

· Monitoring of execution Plans

· Customizing DAC objects and Designing Subject Areas

· Executing Full Load & Incremental Load After Customization

· Import/export of DAC Metadata

· Handling ETL Failures with DAC

· Navigating the DAC Interface

· Real-time View of the BI Apps project with Specification documents