Optional Parameters - Teradata Warehouse Miner

In-Database Analytic Functions User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
August 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
guj1484331868727.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2306
lifecycle
previous
Product Category
Teradata® Warehouse Miner
outputdatabase
The database that contains the resulting output table that represents one or more linear models.
If outputdatabase and outputtablename are not both specified, a volatile output table with randomly generated name is created in the logon user database.
outputtablename
The name of the output table representing one or more linear models. A second output table reporting statistical measures is automatically named on the user’s behalf by appending “_rpt” to the end of this name. These two output tables represent a single linear model with coefficients and statistical measures in the absence of group by columns, or if group by columns are specified, there is a model for each combination of group bycolumn values in these output tables.

Note that both of the output tables must first be dropped by the user if outputdatabase and outputtablename are both specified. If outputdatabase and outputtablename are not both specified, volatile output tables with randomly generated names are created in the logon user database, and the two output result sets are returned to the user instead.

groupby
The input columns dividing the input table into partitions, one for each combination of values in the group by columns. For each partition or combination of values a separate linear model is built. The columns must reside in the table named with the tablename parameter. The default case is no group by columns.

For example: groupby=column1,column2,column3

constant
Set to true if the linear model includes a constant term or false otherwise. The default value is true.