TD_FunctionFit Input - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™

InputTable Schema

Column Data Type Description
input_column VARCHAR (CHARACTER SET LATIN or UNICODE) or NUMERIC Column whose name can appear as TargetColumn in TransformationTable.

TransformationTable Schema

Column Data Type Description
TargetColumn VARCHAR

(CHARACTER SET LATIN or UNICODE)

Name of InputTable column to transform.
Transformation VARCHAR

(CHARACTER SET LATIN or UNICODE)

Transformation to apply to TargetColumn—for allowed transformations, see following table.
Parameters VARCHAR

(CHARACTER SET LATIN or UNICODE)

[Optional] Transformation parameters in JSON format.

If this column is absent and transformation has parameter, function uses default value in Parameters column of the following table.

DefaultValue NUMERIC [Optional] Default value for transformed value if TargetColumn is nonnumeric or NULL.

If this column is absent, function uses default value 0.

Allowed Transformations

If a transformation requires parameters, they are specfied in JSON format as mentioned for log and power in the following table.

Transformation Parameter Operation on TargetColumn Value x
ABS None |x|
CEIL None CEIL (x)

(Least integer ≥ x)

EXP None ex

(e = 2.718)

FLOOR None FLOOR (x)

(Greatest integer ≤ x)

LOG [Optional] {"base": base}

Default: e

LOGbase(x)
POW [Optional] {"exponent": exponent}

Default: 1

xexponent
SIGMOID None 1 / (1 + e-x)
TANH None (ex - e-x) / (ex + e-x)