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.