Verifying Results

Once you have executed sampling, you can view the results.

When compressed sampling is performed, a fingerprint is created. The fingerprint is a unique graphical representation of the distribution of data for the sampled data element. When the results for compressed sampling are loaded, the fingerprint is created.

  1. In the List of Data Stores in the Work with Data Stores window, select the row for the URADAR.DEMOT.TableName data store.
  2. Click the Show Synthetic Data Elements button. The Data Store Data Elements list in the left pane shows the data elements for the data store you selected.
  3. In the Data Store Data Elements list, select the data element OPERAT-NUM.

    You can also select the image for the data element in the Data Element Samples grid. To ensure that you have selected the correct one, the related data element name is highlighted in the Data Store Data Elements list.

    Sampling results for the numeric data element OPERAT-NUM are displayed.

  4. Review the data element fingerprint in the Zoomed Data Element Sample. The fingerprint is the result of performing compressed sampling. Notice the following:
    • The numbers on the vertical y-axes represent the ranges of values based on the decimal place, where each number represents one decimal place to the left of the decimal point. For instance, 0 represents the ones place (0-9), 1 represents the tens place (10-99), 2 represents the hundreds place (100-999), and so on.
    • The numbers on the horizontal x-axes represent a specific range based on the y-coordinate corresponding to the first digit. For instance, 1 represents the value 1 for the y-coordinate 0, while 1 represents values 10-19 for the y-coordinate 1.
    • The values in each cell indicate the number of times a value in the data element falls within the specified range.
    Note: The fingerprint can also be viewed as a bar graph by clicking Graph.
  5. Review the items in the list Sample Analysis of the Selected Data Element. This list shows the actual data element values when standard sampling was performed.
    Note: Only the first 1500 distinct values and ranges display. They are sorted either numerically or alphanumerically based on the data element type.
  6. In the In the Data Store Data Elements list, select the data element COD-CUS. Sampling results for alphanumeric data element COD-CUS are displayed.
  7. Review the data element fingerprint in the Zoomed Data Element Sample. The fingerprint is the result of performing compressed sampling. Notice that the fingerprint for an alphanumeric data element contains four distinct sections:
    Section Type Description Example

    Character Description

    A range of characters in alphabetical order is provided to show how many data elements begin with that character. 

     Spa A  B  C  D  E  F  G  H  I
  J  K  L  M  N  O  P  Q  R  S
  T  U  V  W  X  Y  Z        *

    Number Distribution

    A range of numbers is provided to show how many data elements begin with the indicated number. In the provided example, no data elements begin with numbers. 

      0  1  2  3  4  5  6  7  8  9   
  4

    Type Summary

    An alphanumeric data element can actually be a numeric-only data element or alphanumeric data element. The type summary provides a count of how many data elements fall into either category. In the provided example, all data elements are alphanumeric in type. 

      Num Only          Alpha Only
  4

    Field Length

    The numbers on the vertical y-axes represent the ranges of values specified. The numbers on the horizontal x-axes represent the position of the actual number in that range. For instance, 4 in the provided example means that there are 4 values with a length equal to 10. 

             Field Len.   Val.
         0  1  2  3  4  5  6  7  8  9

 0 -  9
10 - 19  4
20  -->
    Note: The fingerprint can also be viewed as a bar graph by clicking Graph.
  8. Close the Show Synthetic Data Element Contents window to return to Work with Data Stores.
  9. Open the Work with Data Elements window (Environment > Work with Data Elements).
  10. In the Machine ID list, click DATA EXPRES.
  11. In the Company name list, click DEMO.
  12. Click Apply Filter.
  13. Regard the Minimum Value and Maximum Value items in the List of Data Elements, which are the result of performing min/max calculation sampling.
  14. Leave the Work with Data Elements window open, and continue to the next section.
Parent topic: Data Element Sampling