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

Target Options

Target Options

Configure properties for committing data and error recovery in the
Target
fields.
The following table describes target options:
Other Property Options
Description
Truncate Table
Truncates the table before loading it. By default, this is not selected.
Disable Indexes
Disables indexes for faster loading.
Disable Constraints
Disables physical constraints in the database before loading the data to the target and enables the constraints after the data loads.
If 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.
When the target connection is DB2 for zOS and if you select disable constraints, TDM drops and recreates the constraints and moves the data. But the database tablespace goes into Check Pending state and you cannot perform operations on any of the tablespace. You must run the Check Data utility in the current database tablespace.
Disable Triggers
Disables DML triggers on the target database before loading the data to the target and enables the triggers after the data loads. If you enter the target connection type as relational, the
Disable Triggers
option gets selected when you choose the
Truncate Tables
option. If you enter the target connection as a parameter, you must manually select the
Disable Triggers
option.
This option disables only DML triggers.
Optimize Relationship Type for Entities
Optimizes relations in an entity at the plan level. Optimizes relations to ensure a minimal number of major relations such that the operation includes all tables in the entity.
You must have provided criteria at the plan level when you select this option.
Use Netezza Bulk Reader
Uses Netezza bulk reader to read data from a Netezza source connection. Appears if the plan contains a Netezza source connection.
Use Netezza Bulk Writer
Uses Netezza bulk writer to write data to a Netezza target connection. Appears if the plan contains a Netezza target connection.
If you select a Hadoop HDFS target connection, you cannot configure the target options.