Sample - Example #2 (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
    • .1
    • .2
    • .3

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

Only the first 10 rows shown.
Sample - Example #2
cust_id income age years_with_bank nbr_children gender marital_status xsampleid
1362691 26150 46 5 1 M 2 1
1362548 44554 59 9 2 F 4 1
1363160 18548 38 8 0 F 1 3
1363017 0 16 1 0 M 1 3
1362487 6605 71 1 0 M 2 2
1363486 39942 41 1 5 F 4 2
1363200 21015 18 3 0 M 1 3
1363282 25829 29 8 0 F 1 3
1362527 17622 44 1 0 M 2 3
1362609 1929 79 8 0 F 2 3
... ... ... ... ... ... ... ...
... ... ... ... ... ... ... ...
... ... ... ... ... ... ... ...