Advertised Maintenance - 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

This option on the Tools menu brings up the Advertised Objects dialog to maintain the information about advertised output tables, views and procedures stored in the current Advertise Output metadata tables. Advertised Maintenance can also be accessed from the View > View Advertised Output menu option.

The Advertised Objects dialog displays the following fields for each advertised object.
  • Database — The name of the database containing the advertised object.
  • Name — The name of the advertised object.
  • Kind — The type of database object (T-Table, V-View, P-Procedure).
  • Created By — The database user name that created the object.
  • Created — The date and time that the object was advertised.
  • Comment — The database comment, if any, that was associated with the advertised object.
  • Category — The output category of the advertised object: ADS (data set), SCORE (score table), PROFILE, 0 - other.
  • Note — An optional note or comment associated with the advertisement of an object (for example, to indicate a user project). The maximum size is 30 characters.
  • Status — The output status of the advertisement:
    • Missing: not found in the Teradata data dictionary
    • Outdated: the data dictionary entry indicates the object was created after the date and time in the Advertise metadata's Database Objects table
    • blank
    This field is set by clicking Synchronize, described below.
  • Application — The name of the application that advertised this object. This field is blank if advertised by Teradata Warehouse Miner or one of its derivative products.
The Advertised Objects dialog provides the following options.
  • Properties — This button brings up the properties dialog, described below.
  • Macros — This button brings up a dialog that allows the selection of any of the supplied Advertise Output macros and specification of their parameters, if any. Database, table and column drop down boxes can be used to help ensure that valid names are used. If desired, however, database, table and column names can be typed into the parameter fields directly, keeping in mind that only minimal validation is performed on these fields. When a macro is selected and parameters specified, if any, clicking Execute executes the requested macro and display the results in the standard analysis results viewer. For more information, see RESULTS Tab. Note that if new macros have been added in the latest product update, these will be installed if necessary when this button is clicked.
  • View/Edit — Sub-menu items are displayed for the following options:
    • View Object Definition — This option performs a SHOW TABLE, SHOW VIEW or SHOW PROCEDURE command as appropriate, to display the SQL definition of the advertised object.
    • View Data — If the advertised object is of “kind” Table, this option launches the results data viewer used elsewhere in the product for displaying the results stored in a table.
    • View All Advertised Output — Changes the display to include all advertised objects, regardless of category.
    • View ADS Output Only — Changes the display to include only objects in the ADS category.
    • View Score Output Only — Changes the display to include only objects in the Score category.
    • View Profile Output Only — Changes the display to include only objects in the Profile category.
    • View Other Output Only — Changes the display to include only objects in the Other category. (For example, an Export Matrix output table, a Decision Tree Profile table, or an Association analysis saved “reduced input table”).
    • Delete From Metadata… — Brings up a variation of the Metadata Deletion Wizard described in Metadata Maintenance, adapted to delete advertisements rather than projects and analyses. The following features are notable.

      When the advertisement for a procedure has been selected to delete, any advertisements for objects created by the procedure are automatically also selected to delete, with a count given in the message area at the bottom of the display. This is to avoid leaving partial information in the metadata.

      An option is provided to “Drop the actual database objects advertised above”.

    • Synchronize — Clicking this button compares the advertisements of database objects with the Teradata data dictionary entries for these objects in order to set the Status field described above. Note that access to the DBC Tables view is required for this option to function successfully.