Several files create the Hybrid Analysis sample application on Teradata:
A batch file to send commands to MS Interface SQL (ISQL):
install_teradata.bat
A data load script for the TBC sample database:
ha_create_teradata.sql
An SQL file to add constraints to the fact table after the data load has been completed:
ha_altertable_teradata.sql
A FastLoad script file, which loads data to the fact table:
ha_fastload_teradata.sql
An XML file that you use to import a sample OLAP model into the TBC_MD OLAP Metadata Catalog database:
HA_TBC_Model.xml
An XML file that you use to import a sample metaoutline into the TBC_MD OLAP Metadata Catalog database:
HA_TBC_Metaoutline.xml
A text file containing sample data:
ha_sampledata.txt
Setting up the Hybrid Analysis sample application on Microsoft SQL Server consists of performing the following tasks: