Response Tables - 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

Response tables, created from the raw train and test data, are used as inputs.

DROP TABLE IF EXISTS iris_response_train;
CREATE DIMENSION TABLE iris_response_train (pid INTEGER, response VARCHAR);
INSERT INTO iris_response_train SELECT id, species FROM iris_train;

The following query returns the output shown in the following table:

SELECT * FROM iris_response_train ORDER BY pid;
Single_Tree_Drive Example 1 Response Table iris_response_train
pid response
1 1
2 1
3 1
4 1
6 1
7 1
8 1
9 1
11 1
12 1
13 1
14 1
16 1
... ...
DROP TABLE IF EXISTS iris_response_test;
CREATE DIMENSION TABLE iris_response_test (pid INTEGER, response VARCHAR);
  INSERT INTO iris_response_test SELECT id, species FROM iris_test;

The following query returns the output shown in the following table:

SELECT * FROM iris_response_test ORDER BY pid;
Single_Tree_Drive Example 1 Response Table iris_response_test
pid response
5 1
10 1
15 1
20 1
25 1
30 1
35 1
40 1
45 1
50 1
55 2
60 2
65 2
70 2
75 2
80 2
85 2
90 2
95 2
100 2
105 3
110 3
115 3
120 3
125 3
130 3
135 3
140 3
145 3
150 3