Test Data Management 10.5.1
- Test Data Management 10.5.1
- All Products
Other Property Options
Truncates the table before loading it. By default, this is not selected.
Disables indexes for faster loading.
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 Constraintsoption, 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:
If you select this option, TDM does not validate the constraints when enabling them.
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 Triggersoption gets selected when you choose the
Truncate Tablesoption. If you enter the target connection as a parameter, you must manually select the
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.