Course : TRN 302 Oracle BI Applications 7.9.5 Basic Administration
Overview : This course is designed for administrators and developers new to Oracle BI Applications 7.9.5/6 and takes them through the process of installing, configuring and loading an initial system.
With source data taken from Oracle E-Business Suite, delegates will learn how to set up their initial system, configure execution plans, run them and deal with any data loading issues as they arise.
Followed-on by the Oracle BI Applications 7.9.5/6 Customization and Optimization course, these two courses will give delegates a solid grounding in the Oracle BI Applications technology.
Duration : 2 Days
Course Delivery : Instructor-led with labs
Who Should Attend :End-users, developers, project managers
Prerequisites : none
Detailed Course Agenda :
Day 1
1. Introduction to BI Apps 7.9.5 and 7.9.6
2. Installation and Configuration
- Installing BI Apps 7.9.5
- Installing Informatica PowerCenter 8
- Installing DAC
- Setting up RPD and Web Catalog
- Configuring Informatica
- Configuring the DAC
3. Performing the Initial Data Load
- Creating an Execution Plan
- Configuring an Execution Plan
- Running the Execution Plan
- Troubleshooting and Debugging
Day 2
4. Inside the Oracle BI Applications Data Warehouse
- Understanding the data warehouse data model model
- Table categories and types
- Use of constraints, indexes, summaries
- Running basic reports
- Lineage and Metadata
5. Performance Optimization
- Opportunities for Optimization
- Profiling execution plans
- Optimizing execution plans
- Applying Oracle DW features to optimize the Apps DW
- Analyzing Execution Plans using Oracle BI EE
To book this course for your organization, to customize this course or for more information, contact training@rittmanmead.com for more details.
Speak to us now to find out how we can help your BI project deliver.
T: +44 (0) 8446 697 995
T: (888) 631 1410 (USA)
