5.4.6 - Overview of Variable Transformation - Teradata Warehouse Miner

In-Database Analytic Functions User Guide

Teradata Warehouse Miner
November 2018
User Guide

The Variable Transformation analysis reads a single table or view and produces a Select, Create Table, or Create View statement containing transformed columns. This is useful when preparing data for input to an analytic algorithm. For example, a K-Means clustering algorithm typically produces better results when the input columns are first converted to their Z-Score values to put all input variables on an equal footing, regardless of their magnitude. TWM uses a series of dialog boxes to collect parameter information, the SQL for the requested transformations is generated, and the SQL is run. In the in-database version of Variable Transformation, which is independent of other applications, you define the desired transformations in an externally stored procedure call statement. Transformations are performed without the need of the TWM provided the external stored procedure (td_analyze) is installed and the necessary permissions granted.