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. |