Create Table/View Options - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

The use of the option to Store the tabular output of this analysis in the database on the OUTPUT tab, together with an Output Type of Table, results in the generation of the necessary SQL to create a Table in the named database and to insert the selected answer set into the Table. Selecting an Output Type of View results in the generation of the necessary SQL to create a View from the selected answer set. A View appears in the database like a Table, but actually stores a SELECT statement for later execution. The underlying SELECT statement to perform the analysis is not executed until data is selected from the View.