Advertised Object Properties

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K

The Advertised Object Properties dialog is accessed by selecting the Properties button on the Advertised Objects dialog, displaying the properties of the currently selected object, as outlined below.

Advertise Object Properties
Property Description
Advertise Object General properties of Advertises Object.
Database The database that contains the advertised object (table, view or procedure).
Name The name of the advertised object.
Kind
  • T for Table
  • V for View
  • P for Procedure
Category ADS, SCORE, PROFILE or OTHER
Status This attribute is used to indicate an object that is either Missing (not in the dictionary) or Outdated (dictionary has a later entry with the same name) with respect to the Teradata data dictionary.
Created By The database user that created the object.
Created The date and time the object was created.
Comment An optional comment describing the object.
Advertise Note Optional free-form text that may be used to categorize the object (for example, by internal project or purpose).
Row Count Using the Get Count button, the number of rows in a table may be displayed (but only if the advertised object is a table and not a view or procedure).
ADS Properties ADS specific properties of advertised object.
AnchorDB The database containing the anchor table, if any.
AnchorTable The name of the anchor table, if any.
TargetDate The target date if used in the underlying analyses.
ADS Parameters Repeats for each literal parameter, if any.
Name The name of the literal parameter.
Type String, Numeric, Date, Time, Timestamp, or Text
Value A character string representation of the original value of the parameter.
Description The optional description of the literal parameter.
Variables Repeats for each variable…provided for both ADS and Score objects.
Nbr Sequential integer ordering the variables in the ADS.
Variable Name The name of the variable (column).
Description The optional description of the variable.
Variable SQL Pseudo-SQL representing how the variable was derived, concatenating the contributions of referenced analyses, if any, separated by |||.

Note that if a column is simply passed along from a referenced analysis, it is not recorded unless the column name changes via aliasing.

Variable Columns Repeats for each source column contributing to each variable…provided for both ADS and Score objects.
Nbr Sequential integer ordering the variables, and within each variable, the source columns.
Var Name The name of the variable (column).
Source DB Database containing the table or view that contains the contributing column.
Source Table The name of the table or view that contains the contributing column.
Source Column The name of the column that contributed to the creation of the indicated variable.
Score Properties Score specific properties of advertised object.
Input Database The database containing the scoring input table.
Input Table The name of the scoring input table.
Score Columns Repeats for each column in the score table.
Nbr Sequential integer ordering the score output columns.
Column Name The name of the score output column.
Description If available, a generated description of the use of the score output column (for example, Index Column).
Profile Subject Columns Repeats for each column in the profile table.
Subject Database The database that contains the subject table.
Subject Table The name of the profiled subject table.
Subject Column The profiled column.
Description Description of the subject column, if available (for example, Group By).
Procedure Properties Only displayed if advertised object is a procedure.
Default Call Procedure call with parameters simulating the results that would occur if a procedure wasn't used, including default literal parameters, if any.
Product Version Version of TWM or application that created the procedure.
Database Version Version of Teradata that was in use when the procedure was created.
Procedure Parameters Only displayed if advertised object is a procedure, repeating for each procedure parameter, if any.
Nbr Sequential integer ordering the parameters.
Name The name of the parameter.
Description The optional description of the parameter.
SQLType The SQL type string of the parameter. For example, VARCHAR(30).
Original Value A character string representation of the original value of the parameter.
Tables Built Repeats for each table/view built by the procedure, if any.
Database The database that contains the table/view created by the procedure.
Name The name of the table/view created by the procedure.
Procedure Call The procedure call statement in use when the table/view was created by the procedure.
Start Time The date and time when procedure execution began.
Stop Time The date and time when procedure execution completed.
Created By Procedure Only displayed if the advertised object was created by a procedure.
Procedure Database The database that contains the procedure that created the advertised object.
Procedure Name The name of the procedure that created the advertised object.
Procedure Call The actual procedure call reflecting the parameters used.
Start Time Start time of procedure execution.
Stop Time Stop time of procedure execution.
Created By Analysis/Chained Analysis Describes the analysis that created the advertised object, or the procedure that created it if applicable. If chained to other analyses, they may be viewed using the selector underneath the display.
AnalysisType The type of the analysis that created the object (or is chained to it).
Analysis Name The name of the creating or chained analysis.
Analysis Created Date and time the creating or chained analysis was created.
Analysis Description Optional description of the creating or chained analysis.
Metadata Database Metadata database containing the analysis.
Project Name Name of the project containing the analysis.
Project Created Date and time the project was created.
Project Description Optional description of the containing project.