Output - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

The IDWT2D function outputs a message that indicates whether the function succeeded and an output table of transformed (reconstructed) matrices.

IDWT2D Output Message
Column Name Data Type Description
messages VARCHAR Message that indicates whether the function was successful.
IDWT2D Output Table Schema
Column Name Data Type Description
partition_column Inherited from input table column with same name Sequence identifier of the sequence to which the data belongs. Rows with the same partition column values belong to the same sequence.

The output table has a partition_column for every partition_column in the data table.

If the data table has multiple partition columns, the first one is the distribute key in the output table.

If the data table has only one partition_column, the output table has as its distribute key a function-generated column named dwt_idrandom_name. Every cell of dwt_idrandom_name has the value 1.

indexy INTEGER Y index of the reconstructed matrix.
indexx INTEGER X index of the reconstructed matrix.
input_column INTEGER, SMALLINT, BIGINT, BIGSERIAL, DOUBLE PRECISION, NUMERIC [(p, s)], or SERIAL Reconstructed matrix.

The output table has an input_column for every input_column in the data table.