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.
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 |
|
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. |