TD_BinCodeFit Output - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™

Output Table Schema

Column Data Type Description
TD_ColumnName_BINFIT VARCHAR

(CHARACTER SET UNICODE)

target_names_column. Bin column name.
TD_MinValue_BINFIT DOUBLE PRECISION minvalue_column. Minimum value of the bin.
TD_MaxValue_BINFIT DOUBLE PRECISION maxvalue_column. Maximum value of the bin.
TD_LabelPrefix_BINFIT VARCHAR

(CHARACTER SET UNICODE)

[Column appears only with MethodType ('equal-width').] Label prefix.
TD_Label_BINFIT VARCHAR

(CHARACTER SET UNICODE)

[Column appears only with MethodType ('variable-width').] Bin label.
TD_Bins_BINFIT INTEGER target_names_column. Bin count.
TD_IndexValue_BINFIT SMALLINT Index value.
TD_MaxLenLabel_BINFIT SMALLINT Maximum bin label length.
target_column Same as in Input table Target column for TD_BinCodeTransform.

OutputTable Schema

The function outputs this secondary output table only if you specify MethodType ('equal-width').

Column Data Type Description
ColumnName VARCHAR

(CHARACTER SET UNICODE)

The column name of the bin.
MinValue DOUBLE PRECISION The minimum value of the bin.
MaxValue DOUBLE PRECISION The maximum value of the bin.
label VARCHAR

(CHARACTER SET UNICODE)

The label of the bin.