Null Replacement - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

NULL value replacement is offered as a transformation function. A literal value, the mean, median, mode or an imputed value joined from another table can be used as the replacement value. The median value can be requested with or without averaging of two middle values when there is an even number of values. The replacement value can also be the analytic data set’s target date value. Literal value replacement is supported for numeric, character and date data types. Mean value replacement is supported for columns of numeric type or date type, with special coding required for date type. Median without averaging, mode and imputed value replacement are valid for any supported type, with distinct SQL generated for computing the median value of numeric, date and other type columns. Median with averaging is however supported only for numeric and date type columns.