Viewing the current subsetting configuration
To display the Subsetting view, either:
On the workspace management view, in the workspace navigation bar, click Subsetting.
On Workspaces view, from the dropdown menu in the Name column, select Subsetting.
On Workspaces view, click the subsetting icon for the workspace.
The Configuration tab on the Subsetting view shows the current subsetting configuration.
It consists of:
Subsetting summary
Table View and Graph View. Both views display the source data tables and show the current subsetting configuration, and allow you to update the configuration. Table View displays a tabular list of tables. Graph View displays a diagram that shows the relationships between the tables.
Configuration to enable subsetting for data generation
Configuration for handling out-of-subset tables
Results of the most recent subsetting data generation
Subsetting summary
The panels at the top of the Configuration tab provide a clickable summary of the current subsetting configuration.
The summary includes the following values:
Target shows the number of target tables.
Lookup shows the number of lookup tables.
In Subset shows the number of tables that are in the subset. This includes target tables, lookup tables, and related tables.
Out of Subset shows the number of tables that are not in the subset.
When you click a summary panel:
On Table View, the table list is filtered to only display matching tables. For example, when you click Target, the list is filtered to only include target tables.
On Graph View, the matching tables are highlighted with a shadow behind the table objects.
Subsetting data generation results
After you run data generation with subsetting, on Table View, the Latest Results tab displays on the Configuration tab.
Before you run data generation with subsetting, the Latest Results tab does not display.
The Latest Results tab displays details for the most recent data generation with subsetting. It ignores data generation runs that do not use subsetting.
The subsetting results include:
The job status (successful, failed, canceled).
The amount of time it took to complete the run.
The percentage of the source data that is included in the subset destination data.
The volume of data in the source data and the subset destination data.
The percent reduction from the original source data to the subset destination data.
When the job began and ended.
To display the details for the data generation job, click View Job Details.
Table View
Information in the table list
The Configuration tab contains the list of tables in the source database. It shows how each table is affected by the most recently completed subsetting configuration.
For each table, the table list includes:
Whether the table is a target table, a lookup table, or a related table that is filtered.
Whether the table is in or out of the subset. Target and lookup tables are always in the subset. Related tables also are in the subset. Other tables are out of the subset.
The number of rows in the table before and after the subset is created. For tables that are in the subset, the percentage of table data that is in the subset. For more information, go to How Structural determines the number of pre-subset and post-subset rows.
The number of direct inbound (downstream) and outbound (upstream) relationships for the table. An inbound relationship means that a primary key from another table is used as a value in the current table. An outbound relationship means that the primary key of the current table is a foreign key in another table. You can filter the upstream records to only include the records that you need. For target tables, the relationships are used to determine the related tables that are included in the subset. The related tables can also include other tables where the relationship is indirect.
Sorting the list
You can sort the list based on values in a selected column. To use a column to sort the list, click the column heading. To switch the sort order, click the column heading again.
The Sort by dropdown list provides the following options to sort the list:
Rows pre-subset - Sort by the number of rows in the table before subsetting.
Rows post-subset - Sort by the number of rows in the table after subsetting. Before you run a data generation job to create the subset, this value is unknown.
Inbound relationships - Sort the list based on the number of inbound relationships.
Outbound relationships - Sort the list based on the number of outbound relationships.
Total relationships - Sort the list based on the total number of inbound and outbound relationships.
By default, the drop-down sort options sort the table list in descending order. For example, when you select Rows pre-subset, the table that currently has the largest number of rows is at the top of the list. To change the sort direction, select the option again.
Filtering the list
You can filter the list based on:
The table name
Whether the table is in or out of the subset
Whether the table is a target or lookup table
To filter by table name, begin typing the name text into the filter field. As you type, the list is filtered to only include tables whose names contain the filter text.
To filter the list to show only target tables, lookup tables, in-subset tables, or out-of-subset tables, do one of the following:
Click the panel at the top of the tab.
From the Filter Tables drop-down list, select the filter option.
To remove a table subset status filter, click the delete icon.
You can combine a name filter and a table subset status filter. For example, you can filter the list to show in-subset tables that contain the text "test".
You cannot combine the table subset status filters. When you select a different filter, the current filter is replaced.
Graph View
Graph View displays a diagram of the source data tables and the relationships between them. It also indicates:
Whether each table is in the subset.
Whether the subsetting status for the table changed since the last subsetting data generation.
Information on the Graph View table blocks
Each table block provides the following information about the table:
At the top left:
The name of the table
The name of the schema that contains the table
At the top right, the status of the table in the context of the subset. A table might be a target table, a lookup table, a related table that is in the subset, or a table that is out of the subset.
At the bottom, the number of rows in the table before and after the subset is created. For more information, go to How Structural determines the number of pre-subset and post-subset rows.
How relationships display on Graph View
The Graph View diagram connects tables that are related to each other based on a foreign key relationship. The position of the tables indicates the type of relationship.
Tables that have an upstream relationship with another table are displayed above the table.
Tables that have a downstream relationship with another table are displayed below the table.
The Attendees table refers to the event for the attendee. Attendees is upstream of Events, and would display above the Events table in Graph View.
The Events table refers to a venue from the Venues table. Venues is downstream of Events, and would display below the Events table in Graph View.
Focusing on a specific table
To find and focus on a specific table:
In the search field, begin to type text in the table name. As you type, Tonic Structural filters the list to display matching tables.
When you see the table that you want, click the table name. Structural highlights the connections to other tables and displays the table details panel.
Other Graph View navigation options
To navigate around Graph View, you can click and drag to pan around the graph.
You can also use the navigation tools at the bottom left of Graph View to zoom in and zoom out.
How Structural determines the number of pre-subset and post-subset rows
For tables that contain fewer than 1,000 rows, the pre-subset number of rows is displayed as <1k.
For tables that are in the subset, the resulting rows are based on the target table and related table configuration.
If the data generation job hasn't run yet, or the details from the job are not yet available, then the number of rows after the subset is marked as unknown.
If you updated the configuration for a table since the most recent data generation, then on Table View, an information icon displays next to the post-subset value.
Viewing table details
When you click a table in either Table View or Graph View, the table details panel displays to the right of the table.
The table details include:
Whether the table is in the subset
The number of rows before and after the subsetting. For more information, go to How Structural determines the number of pre-subset and post-subset rows.
The number of outbound and inbound relationships
For target tables, the subset configuration
The list of inbound and outbound relationships with other tables. When you click a table name, Structural selects and displays the details for that table.
Last updated