Parameterize a Denorm Analysis as follows:
- Available Tables — twm_accounts
- Index Retain Columns — cust_id
- Index Remove Columns — acct_type
- Denormalize Columns — ending_balance
- Retain Columns — acct_nbr
-
Values to Denormalize
-
Value
SV
CK
CC
-
Prefix
SV_ (Value - SV)
CK_ (Value - CK)
CC_ (Value - CC)
-
Value
- Aggregation Method — MIN
- Treat undefined key values as — Zero
For this example, the Denorm Analysis generated the following results. Note that the SQL is not shown for brevity.
Only the first 10 rows shown.
cust_id | acct_nbr | CC_ending_balance | CK_ending_balance | SV_ending_balance |
---|---|---|---|---|
1363215 | 0000000013632153 | 0.00 | 0.00 | 2689.95 |
1362654 | 0000000013626543 | 0.00 | 0.00 | 622.46 |
1362793 | 4561143213627934 | 407.08 | 0.00 | 0.00 |
1362666 | 0000000013626663 | 0.00 | 0.00 | 300.42 |
1362700 | 0000000013627002 | 0.00 | 4494.03 | 0.00 |
1363400 | 0000000013634003 | 0.00 | 0.00 | 137.85 |
1363374 | 4561143213633744 | 0.00 | 0.00 | 0.00 |
1362941 | 0000000013629413 | 0.00 | 0.00 | 877.14 |
1362586 | 0000000013625862 | 0.00 | 260.70 | 0.00 |
1362883 | 0000000013628833 | 0.00 | 0.00 | 149.74 |
... | ... | ... | ... | ... |
... | ... | ... | ... | ... |
... | ... | ... | ... | ... |