Installing Teradata Warehouse Miner Demonstration Data - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
Release Number
July 2017
English (United States)
Last Update
Product Category

Teradata Warehouse Miner demonstration data can be installed for tutorial purposes. This data is the same data used in the documentation and help system provided with the product. The tables comprising the demonstration data use less than 10 megabytes of permanent space and are built without FALLBACK protection. The table names begin with “twm_” to avoid interference with the names of other tables in the database.

The demonstration table names listed below show that the data emulates customer, account and transaction information from a fictitious bank.
  1. twm_accounts
  2. twm_checking_acct
  3. twm_checking_tran
  4. twm_credit_acct
  5. twm_credit_tran
  6. twm_customer
  7. twm_customer_analysis
  8. twm_customer_dqa
  9. twm_savings_acct
  10. twm_savings_tran
  11. twm_transactions

In order to install the product demonstration tables, you must execute the Load Demonstration Data program item in the Teradata Warehouse Miner program group. This program loads the data by locating the Teradata Client Utility FastLoad. If it exists on the system, you can proceed with the load. Otherwise, an error occurs.

You will be prompted to enter the Hostname, Userid, Password and Database to load the data into. Note that this requires an appropriate entry in the Hosts file to connect properly. See Executing Teradata Client Utilities. The FastLoad program is then invoked to load all the demonstration data - the FastLoad log can be analyzed upon completion.

Any existing copies of the demonstration tables will be replaced during the execution of the Load Demonstration Data program.