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.
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 |
... | ... | ... | ... | ... | ... | ... |
... | ... | ... | ... | ... | ... | ... |
... | ... | ... | ... | ... | ... | ... |