Variable Transformation - 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 Variable Transformation Analysis as follows.

  1. Select twm_tutorials_vc1 (created in Variable Creation Tutorial #1Variable Creation - Example #1) as the Available Table.
  2. Drag and drop the following columns from twm_tutorials_vc1 to the following transformation functions in Created Transformations.
    • cust_id — Retain folder
    • income — Bin Code folder
    • gender — Design Code folder
    • marital_status — Recode folder
    • age — Rescale folder
    • avg_cc_tran_amt — Z Score folder (rename zavg_cc_tran_amt)
  3. Let all of the transformation functions properties default, except as follows. Double-click on the variable name to bring up the Properties dialog.
  4. Do the following to set up gender - Design Code:
    1. Click on the Design Code tab on the Properties dialog and then click Values to bring up the Design Code Values Wizard.
      Variable Transformation Tutorial #1: Design Code Values Wizard

    2. Select both F and M by highlighting them and clicking Add.
    3. Click Finish to exit the Wizard.
    4. The default values of F_gender and M_gender are given for the values of F and M, respectively. Highlight those values and type in Females and Males, accordingly.
      Variable Transformation Tutorial #1: Design Code

  5. Do the following to set up marital_status - Recode:
    1. Click on the Recode tab on the Properties dialog and then click Values to bring up the Recode Values Wizard.
      Variable Transformation Tutorial #1: Recode Values Wizard

    2. Select 1-4 by highlighting them and clicking Add.
    3. Click Finish to exit the Wizard.
    4. Specify recode values as follows: 1-S, 2-M, 3-S and 4-S.
      Variable Transformation Tutorial #1: Recode

  6. Do the following to set up age - Rescale:
    1. Specify a lower bound of 0 and an upper bound of 1 as follows.
      Variable Transformation Tutorial #1: Rescale

  7. Go to the OUTPUT-storage tab.
  8. Select Store the tabular output of this analysis in the database.
  9. Specify that a Table should be created named twm_tutorials_vt1.

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

    Variable Transformation - Example #1 Data
    cust_id income Females Males marital status age zavg_cc_tran_amt
    1362480 4 0 1 M 0.26 0.28
    1362481 2 1 0 M 0.30 -0.39
    1362484 1 1 0 S 0.38 0.07
    1362485 2 1 0 S 0.16 0.05
    1362486 1 1 0 S 0.83 -0.39
    1362487 1 0 1 M 0.76 -0.01
    1362488 1 1 0 M 0.84 -0.39
    1362489 4 1 0 S 0.29 0.61
    1362492 3 1 0 S 0.36 0.15
    1362496 1 0 1 S 0.00 -0.39
    1362497 1 0 1 S 0.01 -0.39
    1362498 1 1 0 M 0.62 -0.39
    1362499 3 0 1 M 0.68 -0.06
    1362500 4 0 1 S 0.36 -0.39
    1362501 5 1 0 M 0.59 0.31
    1362502 2 0 1 M 0.58 -0.39
    1362503 1 0 1 S 0.07 -0.39
    1362504 1 1 0 S 0.03 -0.39
    1362505 1 1 0 M 0.53 -0.39
    1362506 6 0 1 M 0.51 0.98
    1362507 1 1 0 S 0.05 -0.39
    1362508 1 1 0 S 0.70 0.13
    1362509 1 0 1 M 0.91 0.10
    1362510 1 1 0 M 1.00 -0.39
    1362511 1 0 1 S 0.92 -0.01
    1362512 2 1 0 S 0.64 -0.10
    1362513 2 1 0 S 0.25 -0.39
    1362516 3 0 1 S 0.26 0.19
    1362520 5 1 0 S 0.47 0.64
    1362523 1 1 0 S 0.00 -0.39