Partition - Example #1 (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 Partition 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
  • Selected Hash Columns — TWM_CUSTOMER.cust_id
  • Number of Partitions — 10
  • First Partition — 1
  • Last Partition — 1

For this example, the Partition analysis generated the following results. Note that the SQL is not shown for brevity.

Only the first 10 rows shown.
Partition - Example #1 Data
cust_id income age years_with_bank nbr_children Gender marital_status
1362485 22690 25 4 0 F 1
1362550 0 15 0 0 M 1
1362564 14357 77 7 0 F 2
1362566 127848 54 4 1 M 2
1362570 20562 50 0 2 F 2
1362580 29363 36 6 3 F 4
1362586 24476 46 6 0 F 1
1362657 27946 39 8 0 F 1
1362661 19649 66 5 0 M 2
1362663 29030 44 4 0 M 1
... ... ... ... ... ... ...
... ... ... ... ... ... ...
... ... ... ... ... ... ...