Running a Values Analysis - Teradata Warehouse Miner

Teradata Profiler Plug-in User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
November 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wzn1503087325188.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2304
Product Category
Software
  1. Open a Values analysis:
    1. In the Profile Project Explorer, right-click a Values analysis.
    2. Select Open.
  2. Choose the data columns to be included:
    1. Select a database.
    2. Select a table.
    3. Select one or more columns to profile from the Available Columns list.
  3. [Optional] Select to group the columns:
    1. Click the Group By (Optional) tab to view the available columns.
    2. Select one or more columns to Group By. If you select two or more Group By columns, no result graphs are available.
  4. Configure the expert options:
    1. Click .
    2. [Optional] Enter a Where Clause to restrict rows selected by the analysis.
    3. Click OK to apply the Where Clause to the analysis.
  5. Configure the output options:
    1. Click .
    2. [Optional] To save the results to the Teradata Database, select Store Analysis in Database.
    3. Enter the Database and Table name of the results table to be created.
    4. Click OK.
  6. Run the analysis by clicking . The results appear in the Results View.
  7. Load the saved results of the analysis by clicking . The Load icon is enabled only if the analysis was executed after it was saved to ensure the results match the analysis.
  8. Save the analysis by clicking . The analysis definition is saved into the metadata database for this connection.