Data Subset Extraction using Referential Integrity and Combined Data Elements

In this tutorial, you import class information using referential integrity for a DB2 data store. Then you create a method RIMETHOD to use a combined data element.

A combined data element is essentially a dummy data element that you create for ease of use when it comes to manipulating classes. Once a combined data element is created, you can perform operations against the data element like you would for other elements.

Note: Sessions in this tutorial should be done in order.

This tutorial walks you through the data classification and the data subsetting phases. In this session, subsetting is based on referential integrity rules.

Begin this session only after you have completed the DB2 Data Stores Session for the tutorial Simple Data Subset Extraction. You must already be logged in to Data Builder to begin.

In this session, you:

The activation of the field ACTIVATION in the table HSURDRIA is needed if the Data Express knowledge base is located on the mainframe DB2 database and the DB2 tables belong to a distributed database (for example Windows or UNIX DB2). If the DB2 tables are located on z/OS you do not need to activate this filed.

Referential Integrity is not supported for GDG and for multi-format VSAM and sequential files. However, Referential Integrity for VSAM and sequential files (if there is no multi-format) is supported.

The performance related to the extraction process for other DB2 tables (not having RI) is not affected when the field ACTIVATION is set to “Y”.