Creating a Data Set
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 Discover > Columns and select the option Restricted 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.
1. Open a project and add the required data sources and the project components.
2. To create a plan, click Execute and then click Actions > New.
3. Enter a name and optional description for the plan. Click Next.
4. Add and configure the required components.
5. Configure the plan settings.
6. To create a data set, select Test Data Warehouse from the list of target connections.
The Data Set Properties section appears.
7. 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.
8. Enter an application name and application version to identify the data set.
9. Add tags to the data set. Use a comma to separate tags.
10. Configure the error and recovery settings and advanced settings as required.
11. Optionally, configure an override strategy for a data source or a table.
12. To save the plan, click Finish.
13. To generate and run the workflow, click Actions > Generate and Execute in the Plan Properties page.
You can view the job log messages in the Monitor page. When the job completes successfully, you can view the data set in the Data Sets view.