Partition - Example #2 (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 — 3

For this example, the Partition analysis generated the following results. Again, the SQL is not shown.

Only the first 10 rows shown.
Partition - Example #2 Data
cust_id income age years_with_bank nbr_children gender marital_status xpartid
1362527 17622 44 1 0 M 2 2
1363486 39942 41 1 5 F 4 3
1363442 144157 58 5 0 M 2 2
1363282 25829 29 8 0 F 1 3
1363238 5788 35 5 2 F 2 2
1363078 9622 46 6 1 M 2 3
1362830 10933 18 3 0 F 1 2
1362670 8877 26 5 0 F 1 3
1362626 15993 30 0 3 F 2 2
1363404 0 17 2 0 M 1 1
... ... ... ... ... ... ... ...
... ... ... ... ... ... ... ...
... ... ... ... ... ... ... ...