Assigning Estimated Classes

In this exercise, you assign estimated classes to the combined data elements created by the BURDDUR job and to the data elements that compose those combined data elements.

  1. Open the Work with Data Elements window (Environment > Work with Data Elements).
    Note: You can also access the Work with Data Elements window from the main window by selecting the file name, right-clicking to view the context menu, and then by clicking Work with Data Elements of the Selected Data Store.
  2. From the Select Data Elements tab, specify DATAEXPRES as the Machine ID and DEMO as the Company name.
  3. Click the Data Store Attributes tab.
  4. In the DB2 Owner, DL/I DBD list, click DELGT.
  5. Click Apply Filter to further narrow down the list of data elements displayed.
  6. In the List of Data Elements (Filtered) table, view the column Estimated Class.

    The BURDDUR job you ran has created four combined data elements and has automatically estimated class assignments. These assignments are estimated for the newly created combined data elements and for the data elements that compose these combined data elements. (Likewise, if a data element that composes a combined data element already has an assigned class, the data element is not associated with an estimated class.)

    Note: When you performed the Data Masking exercise, the class CODCUS (displayed by its class description COD_CUS MASK EXAMPLE) was assigned to the COD_CUS data element in the CUSTOMER data store. Then, when you ran the BURDDUR job as part of this exercise, the class CODUS became an estimated class assignment for the COD_CUS data element in the ACCOUNT data store.
  7. In the List of Data Elements (Filtered), view the newly assigned estimated classes created for the following data stores:
    ACCOUNT and CCARD data stores
    • CLA0449 - created for the data element OFF_NUM.
    • CLA0450 - created for the data element ACC_NUM.
    • CLA0451 - created for the combined data element, which is comprised of both OFF_NUM and ACC_NUM data elements.
    CCARD and OPERAT data stores
    • CLA0452 - created for the data element CARD_TYPE
    • CLA0453 - created for the data element CARD_NUM
    • CLA0454 - created for the combined data element, which is comprised of both CARD_TYPE and CARD_NUM
    Note: The actual names of your estimated classes will differ as they are system-generated.
  8. Click the Estimated Classes - Confirm tab
  9. In the List of Data Elements (Filtered), select each row that has an estimated class but not an assigned class.
    Note: Not all selected rows are displayed.
  10. Click Confirm Class.

    The Estimated Class names now appear in the Assigned Class column.

  11. Close the Work with Data Elements window to return to the Work with Data Stores window.
  12. Continue to the next section.
Parent topic: Data Subset Extraction using Referential Integrity and Combined Data Elements