Data Explorer - INPUT - Data Selection - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. On the Data Explorer dialog box, click on INPUT.
  2. Click on data selection.
    Data Explorer > Input > Data Selection

  3. On this screen, select:
    • Select Input Source — Select Table, Analysis or MultiTable as the source of input.

      In the Teradata Profiler product, the Analysis choice does not apply and cannot be selected.

      If Table is selected as the input source, the user may choose from available databases, tables and columns as described below.

    • Select Columns From Any Number of Tables
      • Available Databases — Choose the database from which you will select tables.
      • Available Tables — Select the table from which you will select columns.
      • Available Columns — Select columns by highlighting and then either dragging and dropping into the Selected Columns window, or click on the arrow button to move highlighted columns into the Selected Columns window.
        Identity columns should not be selected for analysis (i.e., columns defined with the attribute GENERATE … AS IDENTITY).

        If Analysis is selected as the input source, the user may choose from available analyses, tables and columns as described below. For more information, see Analysis Input Screen.

    • Select Columns From Any Number of Tables
      • Available Analyses — Choose the analysis from which you will select an output table for input. Note that only analyses that create a table or view as output will be available for input to the Data Explorer analysis and not those that merely select data.
      • Available Tables — Select an output table to be used for input.
      • Available Columns — Select columns by highlighting and then either dragging and dropping into the Selected Columns window, or click on the arrow button to move highlighted columns into the Selected Columns window.
        Identity columns should not be selected for analysis (i.e., columns defined with the attribute GENERATE … AS IDENTITY).

      If MultiTable is selected as the input source, the user may choose from available databases and tables as described below.

    • Select Tables From Any Number of Databases
      • Available Databases — Choose the database from which you will select data tables.
      • Available Tables — Select one or more tables that you wish to analyze in their entirety by highlighting and then either dragging and dropping them into the Selected Tables window, or click on the arrow button to move the highlighted tables into the Selected Tables window.
        When the Multiple Tables input option is selected, any columns in the selected tables that are defined with the attribute GENERATED … AS IDENTITY are automatically excluded from analysis.