Oracle BI Apps

Duration : 40 Hrs
  • 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
  •  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
  •  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.


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.
DAC Training Process:
  • Overview on DAC (Data warehouse Administration Console)
  • Architecture and Installation of DAC
  • Overview on DAC Client
  • ntegrating 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


No reviews

Post Review

Review Title
Review Content
View All Categories

Quick Enquiry

Technology Portfolio