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