Required Syntax Elements for TD_BinCodeFit - Teradata VantageCloud Lake

ON clause

Accept the InputTable clause for equal-width bins with generated labels.
Accept the InputTable and FitInput clauses for variable-width bins with specified labels.

TargetColumns

Specify the names of the InputTable columns to bin-code.

The maximum number of target columns is 2018.

MethodType

Specify the bin-coding method:

Method Type	Description
equal-width	Bins have fixed width with auto-generated labels. Function finds minimum and maximum values of target columns (min and max) and computes bin width, w, with this formula: w = (max - min)/k k, the number of bins, is determined by NBins.
variable-width	Bins have specified variable widths and specified labels, provided by FitInput table. Maximum number of bins is 3000.

Method Type

Description

equal-width

Bins have fixed width with auto-generated labels.

Function finds minimum and maximum values of target columns (min and max) and computes bin width, w, with this formula:

w = (max - min)/k

k, the number of bins, is determined by NBins.

variable-width

Bins have specified variable widths and specified labels, provided by FitInput table.

Maximum number of bins is 3000.

NBins

[MethodType ('equal-width') only.] Specify either a single bin value for all the target columns or separate bin values for each of the target columns.