Sample - Example #1 (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
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 — 10

For this example, the Sample analysis generated the following results. Note that the SQL is not shown for brevity, and that the specific rows returned will vary randomly.

Sample - Example #1 Data
cust_id income age years_with_bank nbr_children gender marital_status
1362691 26150 46 5 1 M 2
1362548 44554 59 9 2 F 4
1362811 8011 82 2 0 F 2
1363402 24368 63 3 0 F 1
1363011 90248 55 5 0 M 4
1362826 0 15 0 0 F 1
1363018 46884 36 4 2 M 2
1362793 29120 36 6 2 M 3
1363410 28518 31 1 2 M 3
1362676 7230 62 2 0 M 2