Run a plan to create a data set. Create and run different plans for data generation operations.
You cannot create a data set if the tables contain columns with user-defined data types. If a table contains columns with user-defined data types, mark the columns as restricted before you include the tables in a plan to create a data set. To mark a column as restricted, open the project and click
and select the option
for the required column.
Verify whether the tables in the data source contain primary keys. Create logical keys in all transactional tables that do not have any primary keys. A reset operation might fail if a transactional table with null values does not have primary keys.
If a table contains more than two character columns with a precision of 4000 each, edit the precision to 3,999 or less. A reset operation might fail if a data set contains more than two character columns with a precision of 4,000 each and you do not disable constraints during the reset operation.
You cannot perform
tasks that require a staging connection if a table in the
contains columns with a precision of 4,000 or greater. Edit the precision to 3,999 or less.
Open a project and add the required data sources and the project components.
Optional. Create parameters to use in the plan. You can use project parameters and global parameters.
To create a plan, click
and then click
Enter a name and optional description for the plan. Click
Add and configure the required components.
Configure the plan settings.
To create a data set, select
Test Data Warehouse
from the list of target connections.
Data Set Properties
Enter a data set name. TDM enters the plan name by default. You can edit the name.
When you enter a data set name that does not exist in the test data warehouse, you create the first version of a data set. TDM enters the data set version number.
Enter an application name and application version to identify the data set.
Add tags to the data set. Use a comma to separate tags.
To delete a tag that you enter, click the
icon that appears with the tag. To use the keyboard to delete a tag, press
to select the tag and then press
from the keyboard.
Configure the error and recovery settings and advanced settings as required.
Optionally, configure an override strategy for a data source or a table.
To save the plan, click
To generate and run the workflow, click
Generate and Execute
Optional. To publish the test data to the
, enter a name and select users or user groups to assign permission. You can add tags and enter a description for the
You can view the job log messages in the
page. When the job completes successfully, you can view the data set in the