TD_FunctionFit Input - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-02-17
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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)