OBIA Training

BY
Mindmajix Technologies

Mode

Online

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course and certificate fees

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Oracle Business Intelligence Applications Overview

  • Oracle BI Applications components
  • Business areas supported in Oracle BI Applications

Oracle BI Applications Architecture

  • Oracle BI Applications components overview
  • Oracle BI Applications architecture overview
  • Oracle BI Applications product lifecycle overview

Oracle Business Analytics Warehouse Content

  • 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

Installing Oracle Business Intelligence Applications

  • Preinstallation and deployment requirements
  • Installing Oracle BI Applications prerequisites
  • Installing Oracle BI Applications
  • Performing post-installation system set up tasks

Understanding the ETL Process

  • ETL phases and processing overview
  • Using ODI Studio to explore prebuilt ETL metadata
  • Full ETL and incremental ETL
  • Change capture
  • ETL versus ELT

Functional Configuration for Oracle BI Applications

  • Functional configuration overview
  • Terminology related to Oracle BI Applications configuration
  • Configuration Manager overview
  • Functional Setup Manager overview
  • Creating an implementation project
  • Assigning configuration tasks to developers

Administering and Maintaining Functional Configuration Data

  • Functional configuration data overview
  • Administering and maintaining domains and domain mappings
  • Editing domain members
  • Administering and maintaining data load parameters
  • Administering and maintaining reporting parameters

Managing Load Plans

  • Defining, generating, executing, and monitoring load plans
  • Troubleshooting and restarting load plans
  • Managing load plan parameters

Customizing the Oracle Business Analytics Warehouse

  • Customization types and scenarios overview
  • Overview of category1 and category 2 customizations
  • Impact of patches on customizations
  • Applying an update strategy

Building a Category 1 Customization

  • Adding columns to existing tables in the OBAW
  • Creating custom ETL mappings for a category 1 customization
  • Enabling versioning for a category 1 customization
  • Generating DDL scripts for a category 1 customization
  • Creating and executing a load plan for a category 1 customization

Building a Category 2 Customization

  • Adding a new dimension table to the OBAW
  • Creating custom ETL mappings for a category 2 customization
  • Enabling versioning for a category 2 customization
  • Generating DDL scripts for a category 2 customization
  • Creating and executing a load plan for a category 2 customization

Oracle BI Applications 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

Managing Performance

  • Optimizing performance overview
  • Performance tuning recommendations

Practice Test & Interview Questions

Instructors

Mr Paven
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books