Denorm - Example #1 - 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 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)

  • 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.
Tutorial - Denorm Data
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
... ... ... ... ...
... ... ... ... ...
... ... ... ... ...