Go to main content
1/47
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
ETL Overview
Before Running ETL
About ETL Architecture
About ETL Phases
About the
Oracle Data Integrator
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 Health Check and ETL Diagnostics and Automatic Correction
Downloading Diagnostic Health Check Reports
Downloading Error Data from Diagnostics
Monitoring Load Plan Runs
Restarting Load Plans
About Restartability Grain
Restarting Load Plans Using ODI Studio
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
Fixing Event Queue Knowledge Module
4
Customizing the Oracle Business Analytics Warehouse
What Is Customization in
Oracle BI Applications
?
About the Customization Process
Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
Extending Mappings in 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
Modifying Category 2 SCD Behavior
Adding a Dimension to an Existing Fact
Customizing Fact Datastores and Tasks
Adding a DATE_WID Column to a Fact
Category 2 Customizations: Adding Additional Tables
Additional Information About Customizing
Adding New Fact Tables to Oracle Business Analytics Warehouse
Creating 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
Adding 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
Oracle BI Applications
with Custom Source Domains
Scripting on this page enhances content navigation, but does not change the content in any way.