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

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.
If a table in a PostgreSQL database contains an exclusion constraint and you select the
Disable Constraints
option, TDM does not disable the constraint even though the task completes successfully.
When the target connection is DB2 for zOS and if you choose to 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 tablespaces. You must run the Check Data utility in the current database tablespace.
Skip Validation of Constraints
Skips constraint validation when enabling constraints. Enabled when you choose to disable constraints and select one of the following target connections:
  • Target connection is Oracle.
  • Target connection is ODBC and target JDBC connection is Oracle.
  • Target connection is a connection parameter.
If you select this option, TDM does not validate the constraints when enabling them.
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.