Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Executing a Workflow

Executing a Workflow

After you generate a workflow, you can run the workflow to run sessions from the PowerCenter mappings. If you generated multiple workflows for the same plan, you can run each workflow separately.
You can start a workflow from the
Plan | Properties
view or the
Plan | Workflow
view.
  1. To generate and run a workflow in a single step, in the
    Plan | Properties
    page, click
    Actions
    Generate and Execute
    .
  2. You can generate and run a workflow in separate steps. If the plan you selected contains one workflow, click
    Actions
    Execute Workflow
    in either view.
  3. If the plan you selected contains multiple workflows, click the
    Workflow
    view.
    1. Select the workflow that you want to start.
    2. Click
      Actions
      Execute Workflow
      .
  4. If the plan contains parameters, you must select the parameter values to use in the workflow.
    • Default. The workflow uses the parameter values in the parameter file that you specify in the
      Plan Settings
      page of the plan.
    • Use Parameter File. The workflow uses parameter values in a parameter file that you choose. Click
      Browse
      and select the required parameter file.
    • Add Parameter Values. The workflow uses parameters that you create in the project. A list of parameters included in the plan appears.
      • You can choose to use the default values.
      • You can choose to edit the default values. To edit a parameter value, click the required row and enter the value in the value column. Click the
        Save
        button.
      • Criteria parameters do not appear in the list by default. To include criteria parameters, click the
        Select Parameter
        button to view and select parameters. Parameters that you select appear in the list of parameters. You can then edit the parameter value or use the default value.
        A workflow does not include parameters that do not appear in the list. Select and add the required criteria parameters to the list to ensure that the workflow includes the criteria parameters.
    If you edit the value of a parameter that you cannot override, the change does not take effect. The workflow uses the default value and generates an error in the logs.
    Select the required option and click
    Save
    .
  5. Click the
    Generate and Execute
    button to run the workflow.
  6. View the workflow status in the
    Workflow Execution
    view.
If you run the workflow with the
Disable Constraints
option selected, and TDM fails to enable the constraints after loading the data, the workflow fails. You must then manually enable the constraints in the database and run the workflow again.