Database table or CSV file

Steps

  1. Mark Select up to 32 fields from a table to select the fields to fingerprint.
    1. Use the drop-down list to select a table. CSV files are preselected.
    2. Select one or more fields to fingerprint. These correspond to table columns. Select up to 32 fields per table.
    • (Database tables only) To change the displayed name for one or more fields, click Modify Displayed Names.
    • Review the SQL query that was generated for your selection under Selection as SQL Query.

    Click View Sample Data to make sure that the correct information is fingerprinted.

  2. Select Use the following SQL query to select records to construct a custom SQL query.
    • Enter the query or click Copy Above Query, then modify the copied string.
    • Consult a database administrator when formatting the query, to make sure it doesn’t create any functionality, performance, or stability issues.

    Click View Sample Data to make sure that the correct information is fingerprinted.

  3. Click Next to continue. The system validates the SQL query.
    Important: When selecting the fields to fingerprint, be sure to follow the guidelines in Selecting the data to fingerprint section. Avoid fingerprinting short values, columns with repetitive values, and uninteresting or irrelevant values.
    Note:

    To Informix users: The system cannot fingerprint Informix tables that have names containing a backslash character. There is a workaround, however.

    1. Mark Select up to 32 fields from a table.
    2. Select the table and fields.
    3. Copy the query from the Selection as SQL query
    4. Mark Use the following SQL query to select records.
    5. Paste the query into the box.
    6. Surround the table name with double quotes. For example:
      SELECT "name","id","cc","phone" FROM "blade2\informix".custdb.