Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

1 ETL Overview

• Before You Begin Running ETL Processes
• 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

2 Managing Load Plans

• Overview of Load Plan Life Cycle
• Defining Load Plans
• Copying Load Plans
• Editing Load Plans
• Generating Load Plans
• Scheduling Load Plans
• Executing Load Plans
• Monitoring Load Plan Runs
• Restarting Load Plans
  • Overview of Load Plan Restartability
  • About Restartability Grain
  • Restarting Load Plans
    • Restarting Using ODI Studio
    • Restarting Using ODI Console
  • Troubleshooting Load Plans
  • Alternate Options for Restarting Load Plans
    • Using Mark as Complete
    • Running a Scenario Standalone
  • Related Features and Considerations
• Stopping Load Plans

3 Additional Administration Tasks

• Creating ETL Tables for Siebel Sources
• Generating DDL Warehouse Scripts
• Logging and Diagnostics

A Manage Load Plans User Interface Reference

• Manage Load Plans Toolbar Options
• Manage Load Plans Main Page
  • Manage Load Plans: Fact Groups Tab
  • Manage Load Plans: Data Load Parameters Tab
  • Manage Load Plans: Domains and Mappings Tab
  • Manage Load Plans: Schedules Tab
• Create Load Plan Page
• Copy Load Plan Page
• Edit Load Plan Page
• Load Plan Details Page
• Schedule Load Plan Dialog

B Knowledge Modules Reference

• Oracle BI Applications Integration Knowledge Modules
  • IKM BIApps Oracle Control Append
  • IKM BIAPPS Oracle Event Queue Delete Append
  • IKM BIAPPS Oracle Fact Incremental Update
  • IKM BIAPPS Oracle Incremental Update
  • IKM BIAPPS Oracle Period Delete Append
  • IKM BIAPPS Oracle Slowly Changing Dimension
  • IKM BIAPPS SQL Target Override
  • Nested IKM BIAPPS Oracle Control Append
  • Nested IKM BIAPPS Oracle Event Queue Delete Append