7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
zuk1466006200888
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.