Oracle® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Configuring the Oracle Business Analytics Warehouse Database >

Process of Creating Data Warehouse Tables on a Teradata Database


This section includes the procedures for creating and dropping data warehouse tables on a Teradata database. Before you start, make sure that the tables that you create are case specific by setting the session mode to ANSI in your Teradata ODBC configuration (for more information, see Teradata-Specific Database Guidelines for Oracle Business Analytics Warehouse).

NOTE:  For Unicode environments, perform these procedures using a login that has the default character set UTF-8.

To create data warehouse tables on a Teradata database

  1. Follow the steps in Process of Creating Data Warehouse Tables.

    For Teradata databases, the DAC creates a SQL file to create the schema tables, not the tables themselves.

  2. Copy the SQL file created in step 1 from \conf\sqlgen\sql\Teradata into SQL Assistant and execute the SQL.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.