You can create tables for facts, dimensions, and history.
You can customize the Rational® Insight
data warehouse schema
by adding tables to it.
About this task
To create a table:
- Start IBM® InfoSphere™ Data
Architect and
load the data model.
- Select the schema where you want to add the table, right-click,
and click .
- Type a name for the table.
- In the Properties view, click Tablespaces and
specify the following options:
- Select VSTR_32K for Regular.
- Select VSTR_IDX for Index.
- In the Project Explorer view, right-click the table that
you added and click Generate DDL.
- Make sure to select the following options: Fully qualified
names, CREATE statements, COMMENT ON statements, and IN TABLESPACE
clause.
- Click Next.
- Make sure to select the following options: Check constraint,
Foreign key constraint, Primary key constraint, and Tables.
- Click Next.
- Select Run DDL on server, click Next,
select the data warehouse connection, and click Next.
- When prompted, type the user name and password for the
database connection.
- Click Finish.