Input - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

The input table contains information about houses. All columns have numeric data types. The first three columns represent numeric values, but the other columns represent codes or categories. The following two tables are the input table itself and its schema description, respectively.

Categorize Example Input Table categorize_input
sn price lotsize driveway recroom fullbase gashw airco prefarea homestyle
1 27000 1700 1 0 0 0 0 0 1
2 37900 3185 1 0 0 0 1 0 1
3 42000 4960 1 0 0 0 0 0 1
4 67000 5170 1 0 0 0 1 0 2
5 68000 9166 1 0 1 0 1 0 2
6 132000 3500 1 0 0 1 0 0 3
7 43000 5076 0 0 0 0 0 0 1
8 93000 3760 1 0 0 1 0 0 2
9 44500 3850 1 0 0 0 0 0 1
10 43000 3750 1 0 0 0 0 0 1
... ... ... ... ... ... ... ... ... ...

To check the input data variable types, use this query: \d categorize_input

The query returns:

Table "public"."categorize_input"
Column    | Type    | Modifiers 
-------------------------------
sn        | integer | 
price     | real    | 
lotsize   | real    | 
driveway  | integer | 
recroom   | integer | 
fullbase  | integer | 
gashw     | integer | 
airco     | integer | 
prefarea  | integer | 
homestyle | integer |

Table Type:
fact

Distribution Key:
sn

Compression Level:
none

Storage Type:
row

Persistence:
permanent