Join - Example #1 - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

Parameterize a Join Analysis as follows:

  • Selected Columns
    • TWM_CUSTOMER.cust_id
    • TWM_CHECKING_ACCT.ending_balance (Rename to Chk_Bal)
    • TWM_CREDIT_ACCT.ending_balance (Rename to Crd_Bal)
    • TWM_SAVINGS_ACCT.ending_balance (Rename to Sav_Bal)

For this example, the Join Analysis generated the following results. Note that the SQL is not shown for brevity.

Only the first 10 rows shown.
Join - Example #1 Data
cust_id Chk_Bal Crd_Bal Sav_Bal
1362759 4.62 835.19 79.52
1363088 769.47 739.86 1426.1
1362587 292 859.44 1596.17
1362952 473.45 782.77 232.76
1362771 141.86 1200 2361.62
1363316 947.22 1000 629.06
1363342 14.45 1600 57.96
1362700 4494.03 107.4 315.88
1363448 1961.87 1400 1763.31
1362936 109.31 244.47 792.11
... ... ... ...
... ... ... ...
... ... ... ...