These examples are based on small database tables, and their primary/foreign key relationships are displayed on the Subset definition explanation and rules page.
|Table of contents|
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.
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.
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:
BizDataX Documentation © Built by Ekobit. All rights reserved.