Advertise Output Macros - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

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

What are available ADS tables/views/procedures and their properties and procedures?

TWMX_Get_All_ADS

What are the available Score tables/procedures and their properties and procedures?

TWMX_Get_All_Scores

What are Profile tables/views/procedures profiling tables in a particular database?

TWMX_Get_Profiles_By_Database(subjectDatabase VARCHAR(128) CHARACTER SET UNICODE)

What are the Profile tables/views/procedures profiling a particular table?

TWMX_Get_Profiles_By_Table(subjectDatabase VARCHAR(128) CHARACTER SET UNICODE, subjectTable VARCHAR(128) CHARACTER SET UNICODE)

What are columns profiled by tables/views/procedures profiling a particular table?

TWMX_Get_Profiled_Columns(subjectDatabase VARCHAR(128) CHARACTER SET UNICODE, subjectTable VARCHAR(128) CHARACTER SET UNICODE)

What are the Model Variables of a particular ADS or Score by name?

WMX_Get_Variables(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)

What columns contributed to the Model Variables for this ADS or Score table/procedure?

TWMX_Get_Variable_Columns(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)

What are the literal parameters of a particular ADS by name?

TWMX_Get_ADS_Parameters(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)

What are the output columns contained in this Score table/procedure?

TWMX_Get_Score_Columns(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)

What was the analysis or chain of analyses that built this table/view/procedure?

TWMX_Get_Analyses(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)

What are the properties of the analyses that built this table/view/procedure?

TWMX_Get_Analysis_Properties(objectDatabase VARCHAR(128) CHARACTER SET UNICODE,objectName VARCHAR(128) CHARACTER SET UNICODE)

What are the parameters of a particular procedure by name?

TWMX_Get_Procedure_Parameters(objectDatabase VARCHAR(128) CHARACTER SET UNICODE,objectName VARCHAR(128) CHARACTER SET UNICODE)

What are the tables/views created by a particular procedure by name?

TWMX_Get_Procedure_Tables(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)

What are all the advertised tables/views/procedures?

TWMX_Get_Advertised_Objects

What are the projects that select from a particular table to build a profile, ADS or score table?

TWMX_Get_Projects_Table_Input(inputDatabase CHAR(30), inputTable CHAR(30))

What are the profile, score and ADS analyses that select from a particular table?

TWMX_Get_Analyses_Table_Input(inputDatabase CHAR(30), inputTable CHAR(30))

What are the profile, score and ADS analyses that select from a particular column?

TWMX_Get_Analyses_Column_Input (inputDatabase CHAR(30), inputTable CHAR(30), inputColumn CHAR(30))

What project and analysis created the given table/view/procedure?

TWMX_Get_Creating_Analysis(objectDatabase CHAR(30), objectName CHAR(30))

The macros are used by executing them and supplying parameters if any, with or without parameter names, such as in:

EXEC "twm".TWMX_Get_Profiles_By_Table('twm_source','twm_customer');

-or-

EXEC "twm".TWMX_Get_Profiles_By_Database(subjectDatabase='twm_source');