RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
English website
UK English version





Oracle BI Applications 7.9.6: Implementation for Oracle EBS (D55409GC20)

Tablet Lenovo (7"/8GB/WiFi/Android) gratis*!

Do szkoleń autoryzowanych Oracle 3, 4 lub 5 dniowych w formacie ILT, zamówionych w Database Consulting.
*Promocja ważna do wyczerpania zapasów lub do odwołania i nie łączy się z innymi promocjami ani zniżkami

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D55409GC20

Dla kogo

  • Administrator
  • Architect
  • Developer

Czas trwania

4 dni

Cena bazowa

Cel

  • Customize and extend the OBAW
  • Manage the security and performance of Oracle BI Applications
  • Customize DAC metadata
  • Explore Oracle Business Intelligence Applications foundational concepts and architecture
  • Install and configure Oracle BI Applications
  • Explore the prebuilt extract
  • transform
  • and load (ETL) metadata for Oracle BI Applications
  • Use the Data Warehouse Administration Console (DAC) to run ETL routines to populate the OBAW
  • Explore Oracle Business Analytics Warehouse (OBAW) foundational concepts and architecture

Opis

Working knowledge of Informatica PowerMart or PowerCenter

Tematy

  1. Oracle Business Intelligence Applications Overview
    • Exploring Oracle Business Intelligence (BI) Applications
    • Exploring the key components of Oracle BI Applications
    • Exploring Oracle BI Applications integration with transactional applications
  2. Oracle Business Intelligence Applications Architecture Overview
    • Exploring the Oracle BI Applications logical architecture
    • Exploring the process flow of building the data warehouse
    • Employing the recommended deployment options to maximize data warehouse performance
    • Exploring the core components supporting the Oracle Business Analytics Warehouse (OBAW) and the functions performed by each core component
  3. Oracle Business Analytics Warehouse Content
    • Exploring the content of the Oracle Business Analytics Warehouse (OBAW)
    • Exploring OBAW tables
  4. Installing and Configuring Oracle BI Applications and Related Components
    • Identifying the installation prerequisites
    • Configuring DAC
    • Configuring Informatica Workflow Manager
  5. Understanding the ETL Process
    • Exploring the extract, transform, and load (ETL) process used to load the Oracle Business Analytics Warehouse (OBAW)
    • Identifying the differences between a full load and an incremental load of the OBAW
    • Identifying the applications and mechanisms used to support the ETL process
  6. Working with Informatica Designer
    • Identifying the Informatica repository objects used to configure the Oracle Business Analytics Warehouse (OBAW)
    • Navigating the set of tools in Informatica Designer used to configure Informatica repository objects
  7. Working with Informatica Workflow Manager
    • Navigating Informatica Workflow Manager
    • Running workflows and sessions using Informatica Workflow Manager
    • Monitoring workflows using Informatica Workflow Monitor
  8. Exploring SDE and SIL Mappings
    • Describing the differences between Source Dependent Extract (SDE) and Source Independent Load (SIL) mappings
    • Identifying typical objects and their mechanics in SDE and SIL mappings
  9. Working with the Data Warehouse Administration Console (DAC)
    • Using the tools and views of the Data Warehouse Administration Console (DAC)
    • Describing DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBAW) extract, transform, and load (ETL) process
  10. Configuring Analytical Applications
    • Performing preload configuration steps that apply to Oracle Business Intelligence Applications deployed with any source system
    • Configuring general ledger account hierarchies using general ledger accounting flexfield value set definitions
    • Mapping Oracle general ledger natural accounts to group account numbers
    • Creating a new metric in the repository after adding a new group account number
  11. Customizing DAC Metadata and Running and Execution Plan
    • Creating custom metadata objects in the DAC
    • Running a DAC execution plan and monitoring the results
  12. Customizing the Oracle Business Analytics Warehouse (OBAW)
    • Identifying and describing customization types and scenarios associated with OBAW
    • Applying OBAW customization best practices
  13. Adding Columns to an Existing Dimension Table
    • Completing the steps in a Type I customization of the OBAW
    • Adding a column to an existing dimension table in the OBAW and populating it with data
  14. Adding a New Dimension in OBAW
    • Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse
  15. Integrating Security for Oracle BI Applications
    • Exploring the types of security in Oracle Business Intelligence Applications
    • Describing how Oracle BI integrates with the Oracle Fusion Middleware security platform
    • Identifying how BI Application object and data security integrate with EBS responsiblities
  16. Managing OBAW Performance
    • Exploring strategies for increasing extract, transform, and load (ETL) and query performance
    • Identifying common performance bottlenecks
    • Configuring servers to optimize ETL and query performance

Wymagania

    • Working knowledge of Informatica PowerMart or PowerCenter
    • Basic knowledge of SQL
    • Experience in Business Intelligence
    • Knowledge of Dimensional modeling, and database design

Zgłaszanie uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o kontakt telefoniczny pod numerem (22) 398 47 81

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.