Oracle® Business Intelligence Disconnected Analytics Administration and Configuration Guide > Preparing Applications for Oracle BI Disconnected Analytics > Step 2: Creating and Testing Tables and Indexes in the SQL Anywhere Database >
Scenario for Using SQL Scripts to Create Disconnected Tables and Indexes
A simple retail business application might keep track only of products sold and the stores where sales occur. A disconnected version of this application might consist of two dimension tables (Product and Store) and a central fact table called SalesFact. Each of these three tables would need a corresponding SQL Script file for the disconnected application.
This section describes the SQL Script files for these three tables.
drop table Product;
create table Product (
drop table Store;
create table Store (
drop table SalesFact;
create table SalesFact (
Optionally, Oracle BI Disconnected Analytics applications might have SQL script files for creating one or more indexes on a given table. Continuing to use the simple retail business example, this section describes a SQL script for creating an index on the P_Name column of the Product table.
drop index ProductIX;
create index ProductIX on Product (P_Name);