Manage Load Plans Toolbar Options

The Manage Load Plan window contains the following icons and menu options.

Icon or Menu Option Description

Actions Menu:

Execute Reset Data Warehouse Scenario

This command resets the data warehouse by truncating the W_ETL_LOAD_DATES table. This ensures that the subsequent load will truncate all target tables and do a fresh full load.

Duplicate

Enables you to define a new load plan with the same fact groups as the selected load plan definition but with a different name and identifier.

Generate

Starts the process to build the load plan in the ODI repository. A load plan must build successfully before it can be executed.

Show Generation Status Details

Shows the generation status for each step included in the load plan.

Reset Generation Status

Resets the generation status to Not Generated.

Show Load Plan Details

Launches the Oracle Data Integrator Console, which enables you to view detailed information about the selected load plan.

Execute

Executes a load plan that has been successfully generated.

Show Execution Status Details

Displays the execution details of a load plan that has been executed.

Generation Status: Not Generated

Indicates the load plan has not been generated, or was modified in Configuration Manager without being regenerated.

Generation Status: In Progress

Indicates the load plan is in the process of being generated.

Generation and Execution Status: Succeeded

In the Generation Status column, indicates the load plan was successfully generated.

In the Execution Status column, indicates the load plan completed its run successfully.

Generation and Execution Status: Failed

In the Generation Status column, indicates the load plan generation failed.

In the Execution Status column, indicates the load plan run failed due to an error.

Execution Status: Not Executed

Indicates the load plan has not been executed.

Execution Status: Running

Indicates the load plan is currently running.