Table of Contents

Search

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

Workflow Connections

Workflow Connections

Workflows contain connections to the PowerCenter Integration Service, the TDM repository, and one or more connection objects.
An offline job requires three connections to the TDM repository. When you run a plan with multiple workflows, each workflow requires one connection. You can run a maximum of eight workflows at a time. When you run eight workflows, you need 11 connections. Additional workflows move into the queued state.
Each workflow can use different connections to relational sources and paths to flat files. Choose the connections in the plan.
When you create a plan, you can select the following connections:
  • Source. The connection that is used to connect to the source.
  • Target. The connection that is used to connect to the target.
  • Staging connection. A connection to a database for staging data. The default connection entered in the Preferences view appears. You can change the connection for a plan.
  • Lookup connection. A connection to a database that contains lookup tables.
  • Storage connection. A connection to a database that contains storage tables. The default connection entered in the Preferences view appears. You can change the connection for a plan.
  • Teradata connection. An ODBC connection to a Teradata database.
  • Dictionary connection. A connection to a database that contains a dictionary table for substitution, email masking, and data generation.