Contents

Title and Copyright Information

Preface

• Audience
• Related Documents
• Conventions

New Features for Oracle BI Applications ETL Administrators

1 ETL Overview

• Before Running ETL
• About ETL Architecture
• About ETL Phases
• About the ODI Repository
• About Load Plans
• About Changed Data Capture
• About Knowledge Modules
• About Reverse Knowledge Modules
• About Multi-Source Environments
• About ETL Roles
• About Cloud Sources

2 Managing Load Plans

• Overview of Load Plan Life Cycle
• Defining Load Plans
• Duplicating Load Plans
• Editing Load Plans
• Generating Load Plans
• Scheduling Load Plans
• Executing Load Plans
• About Diagnostics Healthcheck and ETL Diagnostics and Automatic Correction
• Downloading Diagnostic Healthcheck Reports
• Downloading Error Data from Diagnostics
• Monitoring Load Plan Runs
• Restarting Load Plans
  • About Restartability Grain
  • Restarting Load Plans
  • Troubleshooting Load Plans
  • Alternate Options for Restarting Load Plans
  • Related Features and Considerations
• Stopping Load Plans

3 Additional Administration Tasks

• Additional Administration Tasks
• Using a Database Link for ETL
• Fix Event Queue Knowledge Module

4 Customizing the Oracle Business Analytics Warehouse

• What is Customization in Oracle Business Intelligence Applications?
  • About the Customization Process
• Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
  • Typical Steps to Extend Mappings in the Oracle Business Analytics Warehouse
  • Example of Extending the Oracle Business Analytics Warehouse
    • Example of Extracting Data from an Oracle EBS 11.5.10 Data Packaged Source into the ODI Staging Area
    • Example of Loading Data from the Staging Area into an Existing Target Table
    • Tips for Modifying the SQ_BCI_ Interface
  • Other Types of Customizations Requiring Special Handling
    • How to Modify Category 2 SCD Behavior
    • How to Add A Dimension to an Existing Fact
      • Customize Fact Datastores and Tasks
    • How to Add a DATE_WID column to a Fact
• Category 2 Customizations: Adding Additional Tables
  • Additional Information About Customizing
  • Adding a New Fact Table to the Oracle Business Analytics Warehouse
  • Create a Custom Dimension Datastore and Tasks
  • About Creating Custom Fact and Dimension Groups
    • Creating Custom Fact and Dimension Groups in ODI
    • Creating Custom Fact and Dimension Groups in Configuration Manager
      • Creating Custom Dimension Groups
• Category 3 Customizations: Adding New Data as a Whole Row into a Standard Dimension Table
  • How to Add New Data as a Whole Row Into a Standard Dimension Table
  • Configuring Extracts
    • Extracting New Data Using an Existing Source Table
    • Setting Up the Delimiter for a Source File
  • Configuring Loads
• Customizing Stored Lookups and Adding Indexes
  • How Dimension Keys are Looked Up and Resolved
  • Adding an Index to an Existing Fact or Dimension Table
• About Resolving Dimension Keys
• Custom Domains
  • Extending BI Applications with Custom Source Domains