Special Features

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
These special features do not pertain to the Teradata Profiler product.
  • If an advertised variable has no description, then analyses chained through analysis references are searched for a description. If a description is found for a variable with a matching name, it is used in the advertised metadata. See the Get Variables section in Macro Results.

    Note that this is a feature unique to advertising output and is not available when publishing to the Model Manager application, for example.

  • Advertised variables include a column containing pseudo-SQL representing how the variable was derived, concatenating the contributions of referenced analyses, if any, separated by three vertical bars |||. Note that if a column is simply passed along from a referenced analysis this is not recorded, unless the column name changes via aliasing. See the Get Variables section in Macro Results.
  • Information about the columns contributing to each advertised variable is stored in the metadata, identifying the database, table and column for each contributing column. Columns that only contribute to an expert or join clause and do not contribute directly to a variable or a dimension applied to a variable are not included in this information. See the Get Variable Columns section in Macro Results.

The Advertise Output metadata tables include:

TWMX_DatabaseObjects *
TWMX_ObjectAnalyses
TWMX_AnalysisProperties
TWMX_Procedures
TWMX_ProcedureParameters
TWMX_ProcedureObjects *
TWMX_ProfileSubjects
TWMX_ADSFeatures *
TWMX_ADSParameters *
TWMX_Variables
TWMX_VariableColumns
TWMX_ScoreFeatures *
TWMX_ScoreColumns
TWMX_ModelObjects

* updated by stored procedures

The views provided to access the Advertise Output metadata tables include:

TWMXV_DatabaseObjects
TWMXV_ObjectAnalyses
TWMXV_AnalysisProperties
TWMXV_Procedures
TWMXV_ProcedureParameters
TWMXV_ProcedureObjects
TWMXV_ProfileSubjects
TWMXV_ADSFeatures
TWMXV_ADSParameters
TWMXV_Variables
TWMXV_VariableColumns
TWMXV_ScoreFeatures
TWMXV_ScoreColumns
TWMXV_ModelObjects