This examples are based on small database tables, their primary/foreign key relationships displayed in 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 mouse on DEPARTMENTS table and select Subset table details from drop down menu. Set Local custom filter on DEPARTMENTS to DEPARTMENT_NAME='IT' and Confirm criteria. 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 second example let's create a subset database using replacement strategy - random value. On the Design surface create relation that's using LOCATION table as parent and 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: Subset database will have:
BizDataX Documentation © Built by Ekobit. All rights reserved.