7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The input table has more than 3000 rows of price and advertisement information for U.S. cracker brands Sunshine, Keebler, Nabisco, and a private label (such as a store brand). In the input column names:

  • dispbrand means that the seller displayed the brand prominently.
  • featbrand means that the seller featured the brand.
  • pricebrand is the price of the brand.
Approximate Distinct Count Example Input Table crackers (Columns 1-8)
sn id dispsunshine dispkeebler dispnabisco dispprivate featsunshine featkeebler
1 1 0 0 0 0 0 0
2 1 0 0 0 0 0 0
3 1 1 0 0 0 0 0
4 1 0 0 0 0 0 0
5 1 0 0 0 0 0 0
6 1 0 0 0 0 0 0
7 1 0 0 1 0 0 0
8 1 0 0 1 0 0 0
9 1 0 0 1 0 0 0
10 1 1 0 1 0 0 0
11 1 0 0 1 0 0 0
12 1 0 0 0 0 0 0
13 1 1 0 0 0 0 0
14 1 0 1 1 0 0 0
15 1 0 0 0 0 0 0
... ... ... ... ... ... ... ...
Approximate Distinct Count Example Input Table crackers (Columns 9-15)
featnabisco featprivate pricesunshine pricekeebler pricenabisco priceprivate choice
0 0 98 88 120 71 nabisco
0 0 99 109 99 71 nabisco
0 0 49 109 109 78 sunshine
0 0 103 109 89 78 nabisco
0 0 109 109 119 64 nabisco
0 0 89 109 119 84 nabisco
0 0 109 109 129 78 sunshine
0 0 109 119 129 78 nabisco
0 0 109 121 109 78 nabisco
0 0 79 121 109 78 nabisco
0 0 109 113 109 96 nabisco
0 0 109 121 99 86 nabisco
0 0 89 121 99 86 nabisco
0 0 109 109 129 96 nabisco
0 0          
... ... ... ... ... ... ...