My first subset

These examples are based on small database tables, and their primary/foreign key relationships are displayed on the Subset definition explanation and rules page.

To create a new Subset definition select Create subset definition button. Enter subset Name, select Data source and Environment. After confirming Design subset definition screen will be open.

Table of contents
Example 1
Example 2
Example 3

Example 1

Let's create a subset base where all employees are from the 'IT' department. Required tables for this subset are DEPARTMENTS and EMPLOYEE. Drag table DEPARTMENTS from Toolbox to empty Design surface as root table. Right-click with a mouse on the DEPARTMENTS table and select Subset table details from the drop-down menu. Set Local custom filter on DEPARTMENTS to DEPARTMENT_NAME='IT' and Confirm criteria. An icon for Local custom criteria will appear. Drag now table EMPLOYEES as a child of table DEPARTMENTS. Subset relationship pop-up window will be open where the relationship between Department ID should be chosen. Run the subset.

EXPECTED RESULT:

  • The EMPLOYEES table contains: All employees working in the "IT" department (department_id = 60) and their managers working in the department "Executive" (department_id=90)
  • The DEPARTMENTS table contains "IT" and "Executive" Department names.
  • The JOBS table contains jobs related to "IT" and "Executive" Department names.
  • REGIONS, COUNTRIES, and LOCATION tables will also be included in the subset as they are parent table and implicit relationship.

Example 2

In the second example let's create a subset database using replacement strategy - random value. On the Design surface create a relation that's using the LOCATION table as a parent and the COUNTRIES table as a child. Set filter on COUNTRIES table: COUNTRY_ID='IT'. Check inside of a relation connector and set Replacement strategy to Random value. Run the subset.

EXPECTED RESULT:

  • Only Italy is inserted inside of the COUNTRY table and the LOCATION table data is filled with all the COUNTRY_ID="IT". There will be only one REGION, which is "Europe", and only one COUNTRY, which is "Italy"

Example 3

Subset tables REGIONS, COUNTRIES where COUNTRY_ID = 'US', DEPARTMENTS and EMPLOYEES. Add REGIONS to an empty subset and COUNTRIES as the child of REGIONS. Set filter on COUNTRIES table: COUNTRY_ID = 'US'. Add LOCATIONS as the child of COUNTRIES, add DEPARTMENTS as the child of LOCATIONS and add EMPLOYEES as the child of DEPARTMENTS. Run the subset.

EXPECTED RESULT: The subset database will have:

  • All Regions
  • Only one country (US)
  • Every location that is in the US
  • All the departments located in the US
  • All the employees located in the US
  • Every employee that is a manager to managers (with recursion)
  • Every selected employee's job