Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
September 2017
English (United States)
Last Update
Product Category

The item table, recommender_product, contains product categories and their similarity scores. The similarity scores are from column cntb in CFilter Example 2 Output Table cfilter_output1, which contains the number of co-occurrences of the items in product_category_a and product_category_b2.

WSRecommender Example Item Table recommender_product
region product_category_a product_category_b product_similarity
Northern California Consumer Corporate 13
Northern California Consumer Home Office 13
Northern California Consumer Small Business 13
Northern California Corporate Corporate 13
Northern California Corporate Home Office 16
Northern California Corporate Small Business 17
Northern California Home Office Corporate 13
Northern California Home Office Home Office 16
Northern California Home Office Small Business 16
Northern California Small Business Corporate 13
Northern California Small Business Home Office 17
Northern California Small Business Small Business 16

The user table, recommender_user, shows the product preference (business presence) of four companies in four product categories, on a scale of 0 to 10 (10 is highest). For example, the table shows that in the Consumer product category, Walmart has a high business presence, while Staples has none. The prod_preference 0 means that the company has never viewed or bought a product in that category.

WSRecommender Example User Table recommender_user
product_category companyname prod_preference month
Consumer Costco 5 December
Consumer Ikea 3 December
Consumer Staples 0 December
Consumer Walmart 9 December
Corporate Costco 8 December
Corporate Ikea 5 December
Corporate Staples 1 December
Corporate Walmart 0 December
Home Office Costco 0 December
Home Office Ikea 9 December
Home Office Staples 7 December
Home Office Walmart 2 December
Small Business Costco 9 December
Small Business Ikea 0 December
Small Business Staples 8 December
Small Business Walmart 2 December