1.1 - 8.10 - IDWT Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

Output Message Schema

Column Data Type Description
messages VARCHAR Reports whether function succeeded.

OutputTable Schema

The table has reconstructed sequences.

Column Data Type Description
partition_column Same as in input table [Column appears once for each specified partition_column.] Identifier of sequence to which data belongs. Rows with same partition column values belong to same sequence.

If InputTable has multiple partition columns, first one is distribution key in both InputTable and OutputTable.

If InputTable has only one partition column, OutputTable has as its distribution key a function-created column named dwt_id_random_name. Every cell of dwt_id_random_name has the value 1.

indexid INTEGER Index of each reconstructed sequence (starting from 1 for each sequence).
target_column INTEGER, SMALLINT, BIGINT, DOUBLE PRECISION, or NUMERIC [Column appears once for each target_column.] Reconstructed sequence.