TD_RowNormalizeTransform 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-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

InputTable Schema

Column Data Type Description
target_column BYTEINT, SMALLINT,INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION Column to normalize row-wise.
base_column BYTEINT, SMALLINT,INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION [Column appears only with Approach ('INDEX') from the TD_RowNormalizeFit function.]

B value to use in normalizing formula.

accumulate_column Any The input table column names copied to the output table.

FitTable Schema

Column Data Type Description
TD_KEY_ROWFIT VARCHAR

(CHARACTER SET LATIN)

Parameter key.
TD_VALUE_ROWFIT VARCHAR

(CHARACTER SET UNICODE)

Parameter value.
target_column BYTEINT, SMALLINT,INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION [Column appears once for each specified target_column.]

NULL value.