Sample - RESULTS - Data (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
If you are connected to a Teradata database, you can set the layout of the results table in the following ways:
  • Table or Multiple Views — If one of these options is selected, a single table is built. If multiple values have been specified in the Size or Fraction list, a column named xsampleid will be created indicating which sample the row belongs to - a number from 1 to n for each distinct value entered in the Size or Fraction list (depending on stratified sampling options).

    When the Multiple Views option is selected, multiple views are created operating against this table, selecting rows based on xsampleid, but not including xsampleid.

    Sample - RESULTS - Data: Table or Multiple Views
    Name Type Definition
    Columns Same as input type The Selected Columns from the INPUT - data selection tab. If a table is created, those selected columns that are also selected on the OUTPUT - primary index tab comprise the primary index of the created table.
    xsampleid SMALLINT If multiple samples are requested in the Size or Fraction list, this column is included in the created table with values starting at 1 and incrementing for each sample specified (i.e., setting size=10,10,10 will return xsampleid=1, 2, 3).

    When a view is created for each sample, this column is not included in the view.

  • Multiple Tables — If this option is selected, one table will be built for every value in the Size or Fraction list.
    Sample - RESULTS - Data: Multiple Tables
    Name Type Definition
    Columns Same as input type The Selected Columns from the INPUT - data selection tab. Those selected columns that are also selected on the OUTPUT - primary index tab comprise the primary index of the created tables.