TD_SimpleImputeTransform 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
target_column CHAR, VARCHAR, or

(with CHARACTER SET LATIN or UNICODE) or NUMERIC

 Column to find missing values.

Column is in the output from TD_SimpleImputeFit.

FitTable Schema

Column Data Type Description
TD _INDEX_SIMFIT INTEGER Unique row identifier.
TD_TARGETCOLUMN_SIMFIT VARCHAR

(CHARACTER SET UNICODE)

 Target column name (literal_column or stats_column).

Column is in the output from TD_SimpleImputeFit.
TD_NUM_COLVAL_SIMFIT NUMERIC
  • If column is numeric, value substituted for missing value.
  • Otherwise NULL.
TD_STR_COLVAL_SIMFIT VARCHAR

(CHARACTER SET UNICODE)
  • If column is nonnumeric, value substituted for missing value or MODE value of column.
  • Otherwise NULL.
TD_ISNUMERIC_SIMFIT BYTEINT
  • 1 if column is numeric.
  • Otherwise 0.
partition_column Same as in InputTable Column on which input is partitioned.