ODI12C Load Plan Editor FAQS

1. What is the Load Plan Editor in ODI 12c?

The Load Plan Editor is a graphical interface in ODI used to design, manage, and organize Load Plans. It provides a single environment to define execution flows, steps, and their relationships.

 

2. What is the main purpose of the Load Plan Editor?

The Load Plan Editor is used to:

·        Create and organize Load Plan steps

·        Define execution order (serial, parallel, conditional)

·        Manage scenarios and workflow logic

·        Configure step properties

 

3. What is the Steps tab in the Load Plan Editor?

The Steps tab is the main working area where:

·        Load Plan steps are added, edited, and organized

·        The entire execution flow is visually represented

 

4. What is the Steps Hierarchy table?

The Steps Hierarchy table:

·        Displays the structure of the Load Plan

·        Represents each step as a row

·        Shows relationships between parent and child steps

·        Displays key properties of each step

 

5. How can you add steps to a Load Plan?

Steps can be added in multiple ways:

·        Drag and drop components (mappings, packages, variables, procedures, scenarios) from Designer Navigator

·        Use the Add Step Wizard

·        Use the Quick Step tool

 

6. What happens when you drag a component into the Steps Hierarchy?

When you drag a component (like a mapping or package):

·        ODI automatically creates a Run Scenario Step

·        The component is executed as part of the Load Plan

 

7. What is the Add Step Wizard?

The Add Step Wizard is a guided tool that:

·        Helps create different types of steps

·        Allows configuration of step properties during creation

 

8. What is the Quick Step tool?

The Quick Step tool provides a faster way to:

·        Add commonly used steps

·        Quickly build Load Plan structures without using the full wizard

 

9. What is the purpose of the Load Plan Editor toolbar?

The toolbar provides tools to:

·        Create and manage steps

·        Organize the step hierarchy

·        Search and navigate within the Load Plan

 

10. What does the Search option do?

The Search option:

·        Helps locate a specific step in large Load Plans

·        Improves navigation in complex workflows

 

11. What is the Expand All option?

Expand All:

·        Expands all nodes in the Steps Hierarchy

·        Displays the full structure of the Load Plan

 

12. What is the Collapse All option?

Collapse All:

·        Collapses all nodes

·        Provides a simplified view of the Load Plan

 

13. What does the Add Step option do?

The Add Step option:

·        Opens a menu to add new steps

·        Provides access to:

o   Add Step Wizard

o   Quick Step tools

 

14. What does the Remove Step option do?

The Remove Step option:

·        Deletes the selected step

·        Also removes all its child steps

 

15. What are the reorder arrows used for?

The reorder arrows allow you to:

·        Move Up / Down → Change step order

·        Move In / Out → Change hierarchy level
This helps in restructuring the Load Plan flow.

 

16. What is the Properties Panel?

The Properties Panel:

·        Displays details of the selected step

·        Allows editing of:

o   Execution settings

o   Conditions

o   Variables

o   Other step properties

 

17. Why is the Load Plan Editor important?

The Load Plan Editor is important because it:

·        Provides a centralized design interface

·        Simplifies complex ETL workflow creation

·        Enables visual management of execution logic

·        Improves productivity and maintainability