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
B700-1022
lifecycle
previous
Product Category
Software
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.