TDM Subset scripts for tables with no relationships
search cancel

TDM Subset scripts for tables with no relationships

book

Article ID: 377114

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

GTDataMaker – 4.11.14.0
GTSubset – 4.11.15.0

Using datamaker/subset to subset data from a number of tables in a database which have no relation.

Saved the extracts for these table. However, in the database action only select one extract can be selected at a time as seen below:

This means that multiple scripts are needed to be executed to subset the database. Is there a way to get datamaker to generate 1 script with multiple extracts or can multiple tables be added to the extract even if they have no relation.

Environment

TDM 4.11.x

Cause

Product limitation.

Resolution

While the option to select multiple extracts is not possible, there is a workaround for including unrelated tables only in the generated scripts and not in the extract itself.

For that, in the same "Extract Tables" tab, add unrelated tables by moving tables from 'No Data Tables' from the right to the center and generate the scripts.