Build ADS - 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
  1. Parameterize a Build ADS analysis as follows:
    • Selected Columns
      • TWM_CUSTOMER.cust_id
      • TWM_CUSTOMER.nbr_children
      • TWM_CUSTOMER.postal_code (from Variable Transformation - Example #1 in the Variable Transformation Tutorial section)
      • twm_tutorials_vt1.age
      • twm_tutorials_vt1.income
      • twm_tutorials_vt1.marital_status
      • twm_tutorials_vt1.Females
      • twm_tutorials_vt1.Males
      • twm_tutorials_vt1.zavg_cc_tran_amt (from Variable Creation - Example #2 in the Variable Creation Tutorial section)
      • twm_tutorials_vc2.CC_acct
      • twm_tutorials_vc2.CC_bal
      • twm_tutorials_vc2.CK_acct
      • twm_tutorials_vc2.CK_bal
      • twm_tutorials_vc2.SV_acct
      • twm_tutorials_vc2.SV_bal
      • twm_tutorials_vc2.Q1_nbr_trans
      • twm_tutorials_vc2.Q2_nbr_trans
      • twm_tutorials_vc2.Q3_nbr_trans
      • twm_tutorials_vc2.Q4_nbr_trans
    • Anchor Table
      • TWM_CUSTOMER
        • Inner Join to twm_tutorials_vt1 on cust_id
        • Inner Join to twm_tutorials_vc2 on cust_id
  2. Go to the OUTPUT-storage tab.
  3. Select Store the tabular output of this analysis in the database.
  4. Specify that a Table should be created named twm_tutorials_bads1.
    For this example, the Build ADS Analysis generates a table of 747 rows with the 19 columns above joined together and, containing the same cust_id values as the TWM_CUSTOMER table. Note that the SQL is not shown for brevity.
    Build ADS - Sample Data #1