Storage - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

The specific options are explained in the sections defining the output for specific analyses. For more information regarding the Stored Procedure and Advertise Output options, see Stored Procedure Support (Teradata Database) and Advertise Output.

Teradata Database

When connected to a Teradata database, the storage tab may vary depending on the analysis, but typically looks like the panel shown below.

Output Storage on Teradata Database

Aster Database

When connected to a Aster database, the storage tab may vary depending on the analysis, but typically looks like the panel shown below (which applies to Descriptive Statistics functions).

Output Storage on Aster Database

Note that the Stored Procedure, Procedure Comment, Create output table using the FALLBACK keyword and Create output table using the MULTISET keyword fields are not available in Aster.

The following storage tab is a variation that applies to the ADS and Reorganization analyses.

Output Storage on Aster Database (ADS and Reorganization Analyses)

The following output table options are specific to Aster database connections:
  • Table Type
    • Fact Table
    • Dimension Table
  • Distribution Type
    • Distribute by Hash
    • Distribute by Replication
  • Persistence Type
    • Permanent Table
    • Analytic Table
  • Storage Type
    • Row Storage
    • Column Storage
  • Compression Type
    • None
    • Low
    • Medium
    • High
  • Hash Column (only if Distribute by Hash)