7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
WSRecommender Output Table Schema
Column Name Data Type Description
item VARCHAR Name of item that the user viewed or bought. Corresponds to the user table column item_column.
usr VARCHAR Unique user identifier. Corresponds to the user table column user_column.
recommendation DOUBLE PRECISION Recommendation score. If the user viewed or bought the item, this value is the user preference score for the item (in preference_column in the user table). Otherwise, this value is the recommendation score calculated by the function.
new_reco_flag INTEGER New recommendation flag, which indicates whether the item is to be recommended to the user. This value is 1 (yes) if the user never viewed or bought the item and the recommendation score is greater than 0; 0 (no) otherwise.
accumulate_item_column Same as in item table Column copied from the item table.
accumulate_user_column Same as in user table Column copied from the user table.