Optional Syntax Elements for TD_RowNormalizeFit - 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™
OUT clause
Accept the OutputTable clause.
Approach
Specify the normalization method:
Option Description Normalizing Formula
UNITVECTOR (Default) Scales each row of the dataset to have a unit norm or magnitude of 1. X' = X / (sqrt (Σi ϵ [1, n] Xi2))
FRACTION Scales each row of the dataset to have a sum of 1. This function is useful when the values in each row represent fractions or probabilities and need to add up to 1. X' = X / (Σi ϵ [1, n] Xi)
PERCENTAGE Scales each row of the dataset to have a sum of 100. This function is useful when the values in each row represent percentages and need to add up to 100. X' = X*100 / (Σi ϵ [1, n] Xi)
INDEX Scales each row of the dataset to a specified range between V and B. X' = V + ((X - B) / B) * 100
In the normalizing formulas:
  • X' is the normalized value.
  • X is the original value.
  • B is the value in the base column.
  • V is the base value.