Vantage CX uses data sources to insert data into a table.
- Select .
- Select .
- In the name field, type TUT_WEB_EVENTS.This data source populates events from the TUTORIAL_WEB table to the TUTORIAL_CUSTOMER_EVENTS table.
- On the Sources page, select the following:
Connection The Teradata-Vantage connection you created earlier Database The database in which in which you added the sample data Table TUTORIAL_WEB After selecting the table, it moves to the Your selected sources area: - Select Continue.
- On the Joins page, select Continue again. Because there is only one table, you do not need to create a join. However, Vantage CX data sources allow you to combine tables with different types of joins such as inner, outer, and cross joins.
- On the Map and Calculate page, select the following:
Database The database in which you created the Events table Table TUTORIAL_CUSTOMER_EVENTS - Click Select Table.
- In the Map columns area, map each field from the source table to the destination table, as shown here:
Source table field Destination field web_cust_id entity_id page_ts datestamp web_page event Your map should look similar to the following: - Select Continue.
- On the Filter page, select Continue again. You can use filters to limit the data processed by a data source. However, you won’t need filters in this tutorial.
- Select Save.
- Select data source. to see your newly created
Repeat the Creating Data Sources to Populate the Events Table process to create the following other insert data sources:
Source table field (TUTORIAL_TRANS) | Destination field (TUTORIAL_CUSTOMER_EVENTS) |
---|---|
account_id | entity_id |
tran_ds | datestamp |
tran_cd | event |
Source table field (TUTORIAL_SUPPORT) | Destination field (TUTORIAL_CUSTOMER_EVENTS) |
---|---|
customer_id | entity_id |
ticket_ds | datestamp |
issue_cd | event |
The data sources populate the integrated TUTORIAL_CUSTOMER_EVENTS table with data from web interactions, transactions, and support issues. Your list of data sources should look similar to the following:
