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. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: 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. Choose the required Integration Service.
  5. Choose to run the workflow immediately or schedule it for a later time.
  6. 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 global and project parameters included in the plan appears. Global parameters are indicated with an asterisk (*).
      • 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
      .
  7. If the target is the
    test data warehouse
    , you can choose to publish the
    data set
    to the
    self-service portal
    .
    Test Data Manager
    publishes the
    data set
    to the
    self-service portal
    as a
    data pack
    .
    1. To publish the
      data set
      to the
      self-service portal
      , expand the
      Publish to the Self-Service Portal
      section.
    2. Enter a name and optional description for the
      data pack
      .
    3. Optional. Add tags to the
      data pack
      . Use a comma to separate tags.
      To delete a tag that you enter, click the
      X
      icon that appears with the tag. To use the keyboard to delete a tag, press
      Tab
      or
      Shift+Tab
      to select the tag and then press
      Delete
      from the keyboard.
    4. Optional. To add users or user groups for the
      data pack
      in the
      self-service portal
      , click the
      Select Users
      button. The
      Select Users for the Data Pack
      dialog box appears.
    5. Optionally, you can filter and search for the list of users or user groups to add.
    6. Optional. Select the users or user groups to add to the data pack and click
      Select
      .
      TDM adds the current user and administrator users to the data pack by default. You can add other users if required.
  8. Click the
    Generate and Execute
    button to run the workflow.
  9. 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.

0 COMMENTS

We’d like to hear from you!