Denorm - OUTPUT - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

Before executing the analysis, define output options.

  1. On the Denorm dialog box, click on OUTPUT.
    Denorm > Output

    This screen provides the following options:
    • Use the Teradata EXPLAIN feature to display the execution path for this analysis — Option to generate a SQL EXPLAIN SELECT statement, which returns a Teradata Execution Plan.
    • Store the tabular output of this analysis in the database — Option to generate a Teradata TABLE or VIEW populated with the results of the analysis. Once enabled, the following fields must be specified:
      • Database Name — Text box to specify the name of the Teradata database where the resultant Table or View will be created in. By default, this is the “Result Database.”
      • Output Name — Text box to specify the name of the Teradata Table or View.
      • Output Type — Pull-down to specify Table or View.
      • Stored Procedure — The creation of a stored procedure containing the SQL generated for this analysis can be requested by entering the desired name of the stored procedure here. This creates a stored procedure in the user's login database in place of the execution of the SQL generated by the analysis. For more information, refer to Stored Procedure Support in the Teradata Warehouse Miner User Guide (Volume 1), B035-2300.
      • Procedure Comment — When an optional procedure comment is entered, it is applied to a requested stored procedure with an SQL Comment statement. It can be up to 255 characters in length and 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 box, available from the Tools > Preferences menu option.
      • Create output table using the FALLBACK keyword — If a table is selected, it will be built with FALLBACK if this option is selected.
      • Create output table using the MULTISET keyword — If a table is selected, it will be built as a MULTISET table if this option is selected.
      • Advertise Output — The Advertise Output option may be requested when creating a table, view or procedure. This feature “advertises” output by inserting information into one or more of the Advertise Output metadata tables according to the type of analysis and the options selected in the analysis. For more information, see Advertise Output in the Teradata Warehouse Miner User Guide (Volume 1), B035-2300.
      • Advertise Note — An advertise note may be specified if desired when the Advertise Output option is selected or when the Always Advertise option is selected on the Connection Properties dialog box. It is a free-form text field of up to 30 characters that may be used to categorize or describe the output.
    • Generate the SQL for this analysis, but do not execute it — If this option is selected, the analysis will only generate SQL, returning it and terminating immediately.
    For further information about output (including Aster-specific options), see OUTPUT Tab of the Teradata Warehouse Miner User Guide (Volume 1), B035-2300.