Go to main content
1/48
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
Scripting on this page enhances content navigation, but does not change the content in any way.