Sample - OUTPUT - Post Processing - 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 Sample dialog box, click on OUTPUT.
  2. Click on primary index.
    Sample > Output > Post Processing

    • Comment on Output Table — Enter a comment without quotes (up to 255 characters) to be applied to the output table or view via an SQL COMMENT statement. It may contain substitution parameters for the output category (Score, ADS, Stats or Other), project name and/or analysis name (using the tags <Category>, <Project> and <Analysis>, respectively).

      Note that the default value of this field may be set on the Defaults tab of the Preferences dialog that is available from the Tools > Preferences menu option. This field is ignored for volatile tables.

    • Collect Statistics on Primary Index of Output Table — Option to collect statistics on the primary index of the output table via an SQL COLLECT STATISTICS statement. This request is performed for both permanent and volatile tables, except as already noted.
      • Use a Sample in collecting the statistics — Option to specify that a system-selected percentage of rows be used in collecting the statistics rather than performing a full-table scan.
    The following option is available regardless of connection type:
    • Further SQL commands to execute — Free-form SQL commands can be entered here to be executed against the output table during post-processing. It is important to substitute the symbols <T> in place of the name of the output table in these commands so that if the output table or database changes in this analysis, in a Refresh analysis or in the Model Manager web-based application, the correct output table name will be in force. This request is performed for both permanent and volatile tables, except as already noted.
    • Word Wrap — Word wrapping will be applied to the result.

      If stored procedure output is requested for the analysis or for a Refresh chained to the analysis, the last SQL command must be terminated by a semi-colon.

    For further information about output (including Aster-specific options), see OUTPUT Tab in the Teradata Warehouse Miner User Guide (Volume 1), B035-2300.