Oracle BI Applications 11g: Implementation using ODI Training Logo

Oracle BI Applications 11g: Implementation using ODI Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

This Oracle BI Applications 11g: Implementation using ODI training teaches you how to implement Oracle Business Intelligence Applications using Oracle Data Integrator (ODI). It's designed for implementation team members responsible for managing the ETL routines.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is 11g: Implementation using ODI Certification Training about?

This Oracle BI Applications: Implementation Using ODI training provides step-by-step procedures for installing, configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. It begins by exploring Oracle BI Applications components and architecture.

Enrolling in this course gives you the opportunity to view demonstrations of the installation steps and then perform post-installation set up of Oracle Business Intelligence Applications, Oracle Business Analytics Warehouse and Oracle Data Integrator. After the installation, expert Oracle University instructors will help you explore the prebuilt ETL metadata that ships with the products. This will help you gain an understanding of the ETL process and the relationships between the architecture components.


What are the objectives of 11g: Implementation using ODI Certification Training ?

  • Identify and describe the extract, transform, and load (ETL) concepts, products, components, and processes related to Oracle Business Intelligence Applications
  • Identify and describe the products, architecture, and key components of Oracle Business Intelligence Applications
  • Identify and describe the content of Oracle Business Analytics Warehouse
  • Install and set up Oracle Business Intelligence Applications and supporting technology
  • Identify and describe the prebuilt Oracle Data Integrator ETL metadata for Oracle Business Intelligence Applications
  • Use Configuration Manager and Functional Setup Manager to configure Oracle BI Applications
  • Use Configuration Manager to create, generate, execute, and monitor load plans
  • Describe the concepts and techniques for customizing ETL functionality in Oracle Business Intelligence Applications
  • Use Oracle Data Integrator Studio to customize ETL metadata objects and the Oracle Business Intelligence Warehouse
  • Identify and describe the security features of Oracle Business Intelligence Applications
  • Manage the performance of Oracle Business Intelligence Applications and Oracle Business Analytics Warehouse

Who is 11g: Implementation using ODI Certification Training for?

  • Data Modelers
  • Business Intelligence Developer
  • Data Warehouse Developer
  • Data Warehouse Administrator
  • Application Developers
  • Business Analysts
  • Data Warehouse Analyst
  • Technical Consultant

What are the prerequisites for 11g: Implementation using ODI Certification Training?

  • Suggested Prerequisite
  • Experience in Business Intelligence
  • Knowledge of ETL
  • Knowledge of Dimensional modeling
  • Knowledge of Data warehouse design

Available Training Modes

Live Online Training

24 Hours

Classroom Training

3 Days

Course Outline Expand All

Expand All

  • Oracle BI Applications components
  • Business areas supported in Oracle BI Applications
  • Oracle BI Applications components
  • Business areas supported in Oracle BI Applications
  • Oracle BI Applications architecture overview
  • Oracle BI Applications product lifecycle overview
  • Oracle BI Applications components overview
  • Oracle BI Applications architecture overview
  • Oracle BI Applications product lifecycle overview
  • Oracle BI Applications components overview
  • System columns in Oracle Business Analytics Warehouse tables
  • Pre-built star schemas in Oracle Business Analytics Warehouse
  • Oracle Business Analytics Warehouse naming conventions
  • Overview of Oracle Business Analytics Warehouse tables
  • System columns in Oracle Business Analytics Warehouse tables
  • Pre-built star schemas in Oracle Business Analytics Warehouse
  • Oracle Business Analytics Warehouse naming conventions
  • Overview of Oracle Business Analytics Warehouse tables
  • Installing Oracle BI Applications prerequisites
  • Installing Oracle BI Applications
  • Performing post-installation system set up tasks
  • Preinstallation and deployment requirements
  • Installing Oracle BI Applications prerequisites
  • Installing Oracle BI Applications
  • Performing post-installation system set up tasks
  • Preinstallation and deployment requirements
  • Change capture
  • ETL phases and processing overview
  • ETL versus ELT
  • Full ETL and incremental ETL
  • Using ODI Studio to explore prebuilt ETL metadata
  • Change capture
  • ETL phases and processing overview
  • ETL versus ELT
  • Full ETL and incremental ETL
  • Using ODI Studio to explore prebuilt ETL metadata
  • Creating an implementation project
  • Assigning configuration tasks to developers
  • Terminology related to Oracle BI Applications configuration
  • Configuration Manager overview
  • Functional Setup Manager overview
  • Functional configuration overview
  • Creating an implementation project
  • Assigning configuration tasks to developers
  • Terminology related to Oracle BI Applications configuration
  • Configuration Manager overview
  • Functional Setup Manager overview
  • Functional configuration overview
  • Administering and maintaining reporting parameters
  • Administering and maintaining data load parameters
  • Administering and maintaining domains and domain mappings
  • Functional configuration data overview
  • Editing domain members
  • Administering and maintaining reporting parameters
  • Administering and maintaining data load parameters
  • Administering and maintaining domains and domain mappings
  • Functional configuration data overview
  • Editing domain members
  • Managing load plan parameters
  • Defining, generating, executing, and monitoring load plans
  • Troubleshooting and restarting load plans
  • Managing load plan parameters
  • Defining, generating, executing, and monitoring load plans
  • Troubleshooting and restarting load plans
  • Impact of patches on customizations
  • Applying an update strategy
  • Customization types and scenarios overview
  • Overview of category1 and category 2 customizations
  • Impact of patches on customizations
  • Applying an update strategy
  • Customization types and scenarios overview
  • Overview of category1 and category 2 customizations
  • Creating and executing a load plan for a category 1 customization
  • Generating DDL scripts for a category 1 customization
  • Enabling versioning for a category 1 customization
  • Creating custom ETL mappings for a category 1 customization
  • Adding columns to existing tables in the OBAW
  • Creating and executing a load plan for a category 1 customization
  • Generating DDL scripts for a category 1 customization
  • Enabling versioning for a category 1 customization
  • Creating custom ETL mappings for a category 1 customization
  • Adding columns to existing tables in the OBAW
  • Creating and executing a load plan for a category 2 customization
  • Generating DDL scripts for a category 2 customization
  • Creating custom ETL mappings for a category 2 customization
  • Enabling versioning for a category 2 customization
  • Adding a new dimension table to the OBAW
  • Creating and executing a load plan for a category 2 customization
  • Generating DDL scripts for a category 2 customization
  • Creating custom ETL mappings for a category 2 customization
  • Enabling versioning for a category 2 customization
  • Adding a new dimension table to the OBAW
  • Exploring default security settings for Oracle BI Applications
  • Exploring ODI security
  • Tools used to manage Oracle BI Applications security
  • Oracle BI Applications security levels
  • Exploring default security settings for Oracle BI Applications
  • Exploring ODI security
  • Tools used to manage Oracle BI Applications security
  • Oracle BI Applications security levels
  • Performance tuning recommendations
  • Optimizing performance overview
  • Performance tuning recommendations
  • Optimizing performance overview

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

11g: Implementation using ODI Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews