Sample - Example #3 (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
Parameterize a Sample analysis as follows:
  • Available Tables — TWM_CUSTOMER
  • Selected Columns
    • TWM_CUSTOMER.cust_id
    • TWM_CUSTOMER.income
    • TWM_CUSTOMER.age
    • TWM_CUSTOMER.years_with_bank
    • TWM_CUSTOMER.nbr_children
    • TWM_CUSTOMER.gender
    • TWM_CUSTOMER.marital_status
  • Size or Fraction
    • .1
    • .2
    • .3
  • Output Type — Multiple Tables
  • Table Names (3)
    • Twm_Cust_Sample1
    • Twm_Cust_Sample2
    • Twm_Cust_Sample3

For this example, the Sample analysis generated 3 tables of size 75, 149 and 224 that look like the input table. Again, the SQL is not shown, and the specific rows returned will vary randomly. The data page will have a Load button which must be clicked to view the three results.