Introduction to Load Plans

• Load Plans help organize the execution of multiple scenarios in Oracle Data Integrator (ODI) to efficiently populate large data warehouses.
• They help manage thousands of tables and hundreds of scenarios within a batch window.
• A Load Plan organizes scenarios in a hierarchy, where tasks can be executed sequentially or in parallel.

Components of a Load Plan

• A Load Plan is an executable object that can contain a hierarchy of steps.
• The leaf nodes of the hierarchy are Scenarios, which can be related to packages, mappings, variables, and procedures.
• These components are executed as part of the Load Plan.

Working with Variables

• Load Plans allow setting and using variables at multiple levels to manage dynamic execution.
• Refer to the "Working with Variables in Load Plans" guide for more details.

Exception Handling and Restartability

• Load Plans support exception handling strategies to deal with errors during scenario execution.
• They also support restartability, which allows the Load Plan to resume from a specific step after an error.

Execution of Load Plans

• Load Plans can be started, stopped, and restarted through multiple interfaces:
• Command line
• ODI Studio
• ODI Console
• Web Service interface
• They can also be scheduled using built-in schedulers or external schedulers.

Load Plan Instance and Run

• When executed, a Load Plan generates a Load Plan Instance.
• Each execution attempt is a separate Load Plan Run.
• For further details, see "Running Load Plans."

Modifications in Production Environments

• Load Plans can be modified in production environments.
• Steps can be enabled or disabled depending on the production needs.
• Certain design operations, such as creating or deleting steps, are available in development repositories but may not be available in execution work repositories.

Managing Load Plans

• Load Plans are stored in the work repository.
• They can be exported and imported to different repositories for execution in different contexts.
• Load Plans can also be versioned, enabling better version control.

Navigation and Visibility

• Load Plans can be accessed and viewed from both Designer and Operator Navigators.
• They are displayed in the "Load Plans and Scenarios" accordion of the Designer Navigator.
• The "Load Plan Executions" accordion in the Operator Navigator displays Load Plan Runs.