Update the Tutorial Tables | Vantage Customer Experience - Update the Tutorial Database - Vantage Customer Experience

Vantage Customer Experience Path Analysis Tutorial

Product
Vantage Customer Experience
Release Number
1.5
Published
June 2022
Language
English (United States)
Last Update
2022-07-07
dita:mapPath
vkt1594411615815.ditamap
dita:ditavalPath
oyf1565965838286.ditaval
dita:id
vkt1594411615815
Product Category
Teradata Applications
Similar to how you created the prior database tables, you can use Teradata Studio to update the database.
  1. Use the following code to create the CUSTOMER_PROFILE table in the tutorial database:
    CREATE TABLE CUSTOMER_PROFILE
    (
        Entity_id         INTEGER,
        age               INTEGER,
        region            VARCHAR(100),
        voice_calls_avg   DECIMAL(5,0),
        data_usage_avg    DECIMAL(5,0),
        sms_usage_avg     DECIMAL(5,0) 
    );
    This table contains the customer profile attributes
  2. Use the Teradata Studio Load Data Wizard to import the tutorial_customer_profiles.csv file, which is included in the tutorial ZIP file.
  3. Use the following code to create the TUTORIAL_CUSTOMER_EXTENDED_EVENTS table in the tutorial database:
    CREATE TABLE TUTORIAL_CUSTOMER_EXTENDED_EVENTS
    (
        entity_id         INTEGER,
        event             VARCHAR(100) CHARACTER SET LATIN,
        datestamp         TIMESTAMP,
        age               INTEGER,
        region            VARCHAR(100),
        voice_calls_avg   DECIMAL(5,0),
        data_usage_avg    DECIMAL(5,0),
        sms_usage_avg     DECIMAL(5,0) 
    );
    The character set must be LATIN.