Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle BI Applications - Implementation using ODI

( Duration: 3 Days )

The Oracle BI Applications - Implementation using ODI training course 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.

By attending Oracle BI Applications - Implementation using ODI workshop, delegates will learn to:

  • 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

This Oracle BI Applications - Implementation using ODI class is ideal for:
  • Administrators
  • Analysts
  • Architects
  • Developers
  • Implementers

COURSE AGENDA

1

Oracle Business Intelligence Applications Overview

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

Oracle BI Applications Architecture

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

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
4

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
5

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
6

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
7

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
8

Managing Load Plans

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

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
10

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
11

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
12

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
13

Managing Performance

  • Optimizing performance overview
  • Performance tuning recommendations

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X