TD_​GetFutileColumns

It emits the name of the columns which are futile based on 3 scenarios. First, If all values in the columns are unique/distinct, Second, If all the values in the columns are same and Third, If the count of distinctValues in the columns / count of total number of rows in the input table is greater than or equal to the threshold provided in the argument.

Options

CategoricalSummaryColumn
Column from summarytable which provides names of the columns in input table.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.
ThresholdValue
The value upto which a particular column in input table is not considered futile.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The relation that contains input data.
Icon
The CategoryTable is generated using TD_CATEGORICALSUMMARY

Output Ports

Icon
output of TD_GetFutileColumns

Nodes

Extensions

Links