Sample - Example #5 (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 and Aliases
    • 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
  • Sample Style — Stratified
  • Stratified Condition — gender = ‘M’
  • Sizes/Fractions — 1,2,3
  • Stratified Condition — gender = ‘F’
  • Sizes/Fractions — 4,5,6

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

Sample - Example #5 Data
cust_id income age years_with_bank nbr_children gender marital_status xsampleid
1363462 9495 25 4 2 F 3 1
1363081 41876 37 7 0 F 1 1
1362611 24115 48 8 1 F 2 1
1362993 20702 30 0 1 F 3 1
1363066 3240 64 1 0 M 1 1
1363306 15576 46 6 0 F 1 2
1363197 19088 52 2 2 F 2 2
1363400 49258 49 9 0 F 2 2
1362730 12988 37 7 3 F 4 2
1362535 26548 46 5 4 F 4 2
1362999 29403 36 6 2 M 4 2
1363083 22680 64 4 0 M 1 2
1362697 5848 83 3 0 F 1 3
1362492 40252 40 0 5 F 3 3
1363039 0 15 7 0 F 1 3
1362548 44554 59 9 2 F 4 3
1362836 5920 66 6 0 F 3 3
1363266 20889 23 2 0 F 3 3
1363051 0 14 6 0 M 1 3
1362563 14711 73 3 0 M 2 3
1362962 2858 83 3 0 M 4 3