Oracle  BI Apps 7.9.6.x Training Plan

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: 

·                   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 reference

·                   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

Courses Offered in Our Training Institute:

Ø IBM Lotus Notes Domino Server Administration

Ø IBM Lotus Notes Development

Ø IBM Web Sphere Application Server Administration

Ø IBM Web Sphere Process Server Administration

Ø IBM Web Sphere MQ Administration

Ø IBM Message Broker

Ø Oracle Apps R12 HRMS

Ø Oracle Apps R12 Finical

Ø Oracle Apps  SCM

Ø Oracle  BI Apps

Ø Oracle Fusion SOA, SOB,B2B

Ø Oracle DBA

Ø Obiee 11g

Ø Oracle  BI Publisher

Ø Informatica

Ø Micorsoft Dynamics CRM

Ø Hyperion all Modules

Ø Android

Ø Sql Server DBA

Ø Tibco

Ø Tibco I Process

Ø Tibco SIM

Ø Webmethods

Ø Siebel CRM, EAI

Ø Microstrategy

Ø PHP

Ø SAP  Business Objects   & SD

Ø MS  Business Objects

www.futurepointtech.com

info@futurepointtech.com