Overview - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
Release Number
July 2017
English (United States)
Last Update
Product Category

Output options are provided to store the results of most types of analysis as one or more output tables or views. An output option is also provided in most cases to store the SQL generated by these analyses in a Stored Procedure that can easily be re-executed in the same or another application using a CALL statement. In order to make the availability of these output tables, views and stored procedures known, additional metadata tables are provided for advertised output. In addition to identifying available output tables, views and procedures, this metadata contains, if available, information about the data in output tables, the analyses that created them, and the stored procedures, if any, that are available to recreate them.

Users have the opportunity to request that an output table, view or procedure be “advertised” by checking a check box and optionally entering an identifying “advertise note”. This can be done on the output panel available with most analyses, or by using the same options on the analysis parameters panel of a Refresh analysis or an Export Matrix analysis. In this way, metadata can be created about the output of any analysis that creates a permanent output table or view.

When requesting advertised output for a Refresh analysis that refreshes a scoring analysis chained to an ADS analysis, both the output of the scoring analysis and the ADS analysis are advertised. Also, if the creation of profiling tables is requested while scoring a decision tree, both the profiling tables and the score output table will be advertised if advertising is requested on the decision tree scoring output panel.
Advertise output options are stored with each analysis that they are requested for. As an alternative to requesting the advertising of output on each and every analysis, an Always Advertise option is available on the Connection Properties dialog to request that all output be advertised when using a particular datasource.
This may generate a great deal of metadata during the course of using the application.