PCR Input - 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

The following statement creates the input table for the linear regression function. The linear regression function requires the response variable to be in the final column; therefore, strokes must be last in the SELECT list.

CREATE DIMENSION TABLE pcr2 AS 
  SELECT principal_component_1, principal_component_2,
    principal_component_3, strokes 
    FROM pcr1;

This query returns the following table:

SELECT * from pcr2;
PCAPlot Example Input Table pcr2
principal_component_1 principal_component_2 principal_component_3 strokes
-1.27086507768138 -0.0479281470754137 0.732287038132982 -1.13787844393218
0.308542873080396 2.70938975527651 -3.04594531776213 -1.41406253226524
-1.61658595260731 0.712262679264539 0.957505372598163 -0.585510267266074
0.723400299704324 -3.73227341951058 0.574740342890179 0.795410174399195
1.50953494759911 -0.643862090689208 -0.235674114998759 -0.0331420905999665
-1.13206482033264 -0.946451923900274 0.153459109295281 0.519226086066141
-0.447229210945602 0.669928830364427 0.306483821831369 -1.13787844393218
0.956038577607332 -0.649328546941474 -0.825039826251437 0.519226086066141
0.195110284571175 -1.17825238356938 -1.04290585569861 0.795410174399195
-1.02505176519817 -1.2375999732885 0.257874309966305 -0.0331420905999665
-1.98240922334734 0.15900792029492 -0.494890984515027 1.3477783510653
-1.00884248343362 -0.597930103709463 0.301060051568943 -0.30932617893302
1.091766978011 -1.16460787259922 -2.17662153529429 1.3477783510653
-1.93840477808707 -0.0623801090526942 -0.936238178663304 0.519226086066141
-1.14924574475721 1.7169286389402 0.588543776698958 -1.13787844393218
0.144749031593665 1.56905010871957 0.524840214232052 -0.585510267266074
-0.65879037722031 0.120392373582135 0.91577182173494 1.07159426273225
0.830295227878681 0.204892485389732 -0.205590257682167 0.243041997733087
-1.57924450867301 0.122683543836927 1.080304476172 -1.13787844393218
3.08093421824054 0.79449565167508 1.2894482577175 -0.861694355599128
0.0232126330286094 -0.37209890913809 -0.867874315202764 1.3477783510653
3.77988804114414 0.628132449973151 0.744457517669957 -1.13787844393218
0.121200199618047 2.08086374773324 0.786060284561277 -1.41406253226524
-0.2155665536251 -0.989679133035365 -0.169609921563112 0.795410174399195
1.25962718383174 0.134364427459239 0.787553912561685 1.62396243939836