1.0 - 8.00 - WSRecommender Output - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
May 2019
Content Type
Programming Reference
Publication ID
English (United States)

Output Table Schema

Column Data Type Description
item VARCHAR Name of item that user viewed or bought. Corresponds to user_table column item_column.
usr VARCHAR Unique user identifier. Corresponds to user_table column user_column.
recommendation DOUBLE PRECISION Recommendation score. If user viewed or bought item, this value is user preference score for item (in user_table column preference_column; otherwise, it is calculated by function.
new_reco_flag INTEGER New recommendation flag. Indicates whether to recommend item to user: 1 (yes) if user never viewed or bought item and recommendation score is greater than 0; otherwise, 0 (no).
accumulate_item_column Same as in item_table [Column appears once for each specified accumulate_item_column.] Column copied from item_table.
accumulate_user_column Same as in user_table [Column appears once for each specified accumulate_user_column.] Column copied from user_table.