The core features of Data Subsetting from Test Data Automation include:
Table, query, and runtime parameters. Subset parameters are defined quickly and simply in Microsoft Excel. You can set-up multiple queries and reference tables to use during the extract.
Auto-population of a full parameter spreadsheet. The Advanced Control Spreadsheet is created automatically from an initial set-up spreadsheet (the Basic Control Spreadsheet), accelerating the granular definition of Data Subsets.
High performance extracts. "Cascade" joins walk from one table to another for rapid extracts.
Recursive subsetting. You can select data recursively, gathering chains of data. Filtering rules further allows you to iterate until you have subsetted the perfect data set.
Targetted subsetting. You can subset only as much as you need, using found criteria or setting either a maximum number of rows or iterations. Alternatively, the subset will end when the last iteration did not insert any additional rows.
Data de-deduplication. Rows are not added to a Subset if they already exist in the target database, creating a smaller and leaner set of data.
Supporting utilities. Additional TDM utilities can be run during or after a Subset, including truncation and environment preparation.
On demand Subsets. Configured Subsets can be exposed to a shared web portal. Anyone with requisite permissions can then trigger and run a Subset on demand, increasing testing agility.