Denorm - INPUT - Data Selection - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Teradata Warehouse Miner
Release Number
November 2018
English (United States)
Last Update
Product Category
  1. On the Denorm dialog box, click on INPUT.
  2. Click on data selection.
    Denorm > Input > Data Selection

  3. On this screen, select:
    • Select Input Source — Users may select between different sources of input. By selecting Table, the user can select from available databases, tables (or views) and columns in the usual manner. By selecting Analysis, however, the user can select directly from the output of another analysis of qualifying type in the current project. Analyses that may be selected from directly include all of the Analytic Data Set (ADS) and Reorganization analyses (except Refresh). In place of Available Databases, the user may select from Available Analyses, while Available Tables then contains a list of all the output tables that will eventually be produced by the selected analysis, or it contains a single entry with the name of the analysis under the label Volatile Table, representing the output of the analysis that is ordinarily produced by a Select statement. For more information, refer to INPUT Tab in the Teradata Warehouse Miner User Guide (Volume 1), B035-2300.

      When selecting from an analysis other than a Variable Transformation, whose option to Generate the SQL for this analysis, but do not execute it is set to true and whose option to Store the tabular output of this analysis in the database is not set to true, the SQL generated for the referenced analysis is embedded as a derived table in the SQL for this analysis, rather than the SQL for this analysis selecting from a volatile table created by the referenced analysis.

    • Select Columns From a Single Table
      • Available Databases (or Analyses) — All the databases (or analyses) which are available for the Denorm analysis.
      • Available Tables — All the tables that are available for the Denorm Analysis.
      • Available Columns — All the columns within the selected table that are available for the Denorm analysis.
      • Selected 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. Make sure the correct category is highlighted (click to expand/highlight):
        • Index Retain Columns — List of index columns to retain (not remove) in resultant denormalized table.
        • Index Remove Columns — List of index columns to remove (denormalize by values of these columns).
        • Denormalize Columns — List of columns/aliases to denormalize (i.e., replicate for given values of removed index columns).
        • Retain Columns — List of columns to retain which are already denormalized (i.e., have a constant value over the selected values of removed key columns).