1. How can you add steps to a Load Plan?
You can add steps using:
· Add Step Wizard
· Quick Step Tool
· Drag and drop components (packages, mappings, variables, procedures, scenarios) from Designer Navigator
2. What happens when you drag and drop a component into the Steps Hierarchy?
When you drag a component:
· ODI automatically creates a Run Scenario Step
· The component is executed as part of the Load Plan
3. What are the two main methods to add Load Plan steps?
The two methods are:
· Add Step Wizard → Guided step creation
· Quick Step Tool → Fast step creation with default settings
4. What is the Add Step Wizard?
The Add Step Wizard is a guided interface that:
· Helps create different step types
· Allows configuration of step properties during creation
5. What are the steps to use the Add Step Wizard?
To use the Add Step Wizard:
· Open Load Plan Editor → Steps tab
· Select a step in the hierarchy
· Click Add Step > Add Step Wizard
· Choose Step Type and Step Location
· Configure step details
· Click Finish
6. What step types can be added using the wizard?
You can add:
· Serial
· Parallel
· Run Scenario
· Case
· When
· Else
7. What is Step Location in the Add Step Wizard?
Step Location defines where the new step will be inserted:
· Child step → Inside selected step
· Sibling before → Same level, before selected step
· Sibling after → Same level, after selected step
8. What happens when a step is added?
When a step is added:
· It is inserted with minimum required settings
· You can later modify it in the Properties Panel
9. How do you create a Run Scenario step using the wizard?
To create a Run Scenario step:
· Select scenario using Lookup Scenario
· Or create a new scenario from an executable object
· Assign Scenario Name and Version
· Optionally add variables to Load Plan
10. What is the use of version -1 in a Run Scenario step?
Using version -1:
· Executes the latest version of the scenario
11. Can you create a Run Scenario step without an existing scenario?
Yes:
· You can enter Scenario Name and Version manually
· Later, you can link it to an actual scenario
12. How is a Case step configured?
For a Case step:
· Select a variable
· Use it for conditional branching
· The step name is auto-generated (can be modified)
13. How is a When step configured?
For a When step:
· Select an operator (e.g., =, >, <, IS NULL)
· Enter a value
· Condition determines execution
14. What operators are available in When steps?
Common operators:
· <, <=, >, >=
· =, <>
· IS NULL, IS NOT NULL
15. What is an Else step?
An Else step:
· Executes when no When condition is satisfied
· Step name is auto-generated
16. What is the Quick Step Tool?
The Quick Step Tool:
· Allows fast creation of steps
· Uses default values
· Reduces design time
17. How do you use the Quick Step Tool?
To use Quick Step:
· Open Steps tab
· Select a parent step
· Click Add Step
· Choose step type (Serial, Parallel, etc.)
18. What types of steps can be added using Quick Step?
Quick Step supports:
· Serial step
· Parallel step
· Run Scenario step
· Case step
· When step
· Else step
19. Can all step types be added anywhere?
No:
· Only valid step types for the selected step are enabled
· ODI restricts invalid hierarchy combinations
20. Can steps be reordered after adding?
Yes:
· Use drag and drop
· Use toolbar arrows (Move Up, Down, In, Out)
21. What is the benefit of using Add Step Wizard vs Quick Step?
· Add Step Wizard → Detailed configuration, better for complex steps
· Quick Step Tool → Faster, better for simple or repetitive steps
22. What are best practices when adding Load Plan steps?
· Use wizard for complex logic
· Use quick step for speed
· Clearly define step hierarchy
· Assign meaningful step names
· Configure variables and conditions properly
No comments:
Post a Comment