TD_SimpleImputeTransform Function Syntax | Teradata Vantage - TD_SimpleImputeTransform Syntax - Teradata® Database

TD_SimpleImputeTransform syntax depends on whether the TD_SimpleImputeFit call that output FitTable omitted or specified PartitionColumn.

TD_SimpleImputeFit Call Omitted PartitionColumn

SELECT * FROM TD_SimpleImputeTransform (
  ON { table | view | (query) } AS InputTable PARTITION BY ANY
  ON { table | view | (query) } AS FitTable DIMENSION
) AS alias;

TD_SimpleImputeFit Call Specified PartitionColumn

SELECT * FROM TD_SimpleImputeTransform (
  ON { table | view | (query) } AS InputTable PARTITION BY partition_column
  ON { table | view | (query) } AS FitTable DIMENSION PARTITION BY partition_column
) AS alias;