Overview of Variable Transformation - Teradata Warehouse Miner

In-Database Analytic Functions User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.2
Published
October 2016
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
zyl1473786378775.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2306
lifecycle
previous
Product Category
Teradata® Warehouse Miner

The Variable Transformation analysis reads a single table or view as input and produces a SELECT statement, Create Table or Create View statement containing transformed columns. This is particularly useful when preparing data for input to an analytic algorithm. For example, a K-Means clustering algorithm will typically produce 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. In classic Teradata Warehouse Miner you use a series of dialogs to collect parameter information, the SQL for the requested transformations is generated, and the SQL is executed. In the in-database version of Variable Transformation, which is independent of other applications, you define the desired transformations in an external stored procedure call statement. Transformations can be performed without the need of the Teradata Warehouse Miner client application, provided that the external stored procedure (td_analyze) is installed and the necessary permissions granted.