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
IDWT Example Output Message
messages
IDwt finished successfully!

The query below returns the output shown in the following table:

SELECT * FROM climate_reconstruct ORDER BY city, indexid;

The output table is the same as the input table to the DWT function (Input). The original values for the temperature, pressure and the dew point are reconstructed.

IDWT Example Output Table climate_reconstruct
city indexid temp_f pressure_mbar dewpoint_f
Asheville 1 34.9000015258789 1020.5 28.8999996185303
Asheville 2 34.4000015258789 1020.20001220703 28.7000007629395
Asheville 3 33.9000015258789 1020 28.3999996185303
Asheville 4 33.4000015258789 1020.20001220703 28.2999992370606
Asheville 5 33.0999984741211 1020.20001220703 28
Asheville 6 32.7000007629395 1020 27.8999996185303
Asheville 7 32.5 1020.29998779297 27.7000007629395
Asheville 8 32.2999992370606 1020.79998779297 27.6000003814697
Asheville 9 32.0999984741211 1021.29998779297 27.3999996185303
Asheville 10 33.7999992370606 1021.70001220703 28.2000007629395
Asheville 11 36.4000015258789 1022.09997558594 28.8999996185303
Asheville 12 39.4000015258789 1022 29.2999992370606
Asheville 13 42.0999984741211 1021.09997558594 29.2000007629395
Asheville 14 44.2000007629395 1020 29.1000003814698
Asheville 15 45.5999984741211 1019.29998779297 28.8999996185303
Asheville 16 46.2000007629395 1019 28.5
Asheville 17 45.7999992370606 1019.20001220703 28.5
Asheville 18 44.0999984741211 1019.59997558594 28.6000003814698
Asheville 19 41.2000007629395 1020.09997558594 28.5
Asheville 20 39.5999984741211 1020.59997558594 28.7999992370606
Asheville 21 38.2000007629395 1020.90002441406 29
Asheville 22 37.2000007629395 1021.09997558594 29
Asheville 23 36.2999992370606 1021 29
Asheville 24 35.5 1020.90002441406 29
Brownsville 1 35.0999984741211 1020.5 28.8999996185303
Brownsville 2 34.5999984741211 1020.20001220703 28.7999992370606
Brownsville 3 34.0999984741211 1020 28.5
Brownsville 4 33.7000007629395 1020.09997558594 28.3999996185303
Brownsville 5 33.2999992370606 1020.20001220703 28.2000007629395
... ... ... ... ...