Creating a table

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

Feedback