Export Matrix - Example #2 (Teradata Database) - 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
  1. Parameterize an Export Matrix analysis as follows:
    • Selected Matrix — Customer_Analysis_Matrix_Short

    • CSSCP — Enabled

    • Create Table — Enabled

    • Table Name — Twm_CSSCP_Matrix

  2. Run the analysis.
  3. View the results with a Free Form SQL analysis by executing the following queries.
    SHOW TABLE <result_db>.Twm_CSSCP_Matrix;
    SELECT * from <result_db>.Twm_CSSCP_Matrix order by 1;

    Note the following results:

    CREATE SET TABLE <result_db>.Twm_CSSCP_Matrix ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
     XIDX INTEGER,
     XCOL VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
     income FLOAT,
     age FLOAT,
     years_with_bank FLOAT,
     nbr_children FLOAT,
     marital_status FLOAT,
     female FLOAT)
    UNIQUE PRIMARY INDEX ( XIDX );
    Export Matrix - Example #2 Results (Pt. 1)
    XIDX XCOL income age years_with_bank
    0 income 367897869180.964 77558080.3574296 1799836.3975904
    1 age 77558080.3574296 272572.4283802 6924.0682731
    2 years_wi 1799836.3975904 6924.0682731 5340.626506
    3 nbr_chil 5179600.8795181 -899.9196787 -76.6746988
    4 marital_ 3656455.7389558 4332.1740295 -19.1285141
    5 female -1209868.5100402 -60.3266399 -4.3895582

    ...

    Export Matrix - Example #2 Results (Pt. 2)
    XIDX XCOL nbr_children marital_status female
        9600.8795181 3656455.7389558 -1209868.5100402
    1 age -899.9196787 4332.1740295 -60.3266399
    2 years_wi -76.6746988 -19.1285141 -4.3895582
    3 nbr_chil 908.2650602 349.9076305 -3.811245
    4 marital_ 349.9076305 593.6331995 .2423025
    5 female -3.811245 .2423025 184.0990629