Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Integrating Additional Data > Creating New Tables >

Using Existing Tables to Create New Tables

You can use existing tables in Siebel Customer-Centric Enterprise Warehouse to create new tables by making a copy of the table that most closely corresponds with your needs. This is the simplest way to make sure the table format is correct, and it saves time if some of the required columns are already present. The following procedure provides information on creating a target table. If the table is used as a source as well, you can copy the table into the Sources folder and modify its properties as necessary.

To create new target tables by copying existing tables

1. In PowerCenter Designer, open the Siebel Business Analytics folder, unless you are making a new staging table, in which case select the specific source configuration folder.
2. On the Tools menu, click Warehouse Designer.
3. Open the Targets folder, copy the table most closely representing the table you want to create, and drag it into the Warehouse Designer.
   • If you use the copy and paste functions in the Edit menu and you paste them back into the Siebel Business Analytics folder, you are prompted to rename the table because it already exists.
   • By default all tables in Siebel Customer-Centric Enterprise Warehouse are created with a database type of DB2. If you want to select a different database type, select the Database Type list window and select from the list.
4. Open the new table in Warehouse Designer to edit its properties.
5. Click the Columns tab and add, delete, or modify columns as necessary.

   Be sure to conform column to format for data type, length, and precision.

6. Click the Indexes tab, and then click the New Insert button to enter the table name with the appropriate index suffix.

   NOTE:  The format for the index is [TABLE_NAME]_N[SEQUENTIAL_NUMBER] for nonunique indexes or [TABLE_NAME]_U[SEQUENTIAL_NUMBER] for unique indexes. For example, IA_BANK_LOCAL_N1 or IA_BANK_LOCAL_U1. Although indexes are not required, they help speed processing time by connecting the nonunique tables.

7. Click the New Insert button in the Columns window to open the Add Column to Index dialog box.
   • Highlight the column from the list that you want the index to look for and click OK.
   • You must repeat clicking the New Insert button, highlighting the appropriate column and then clicking OK for each column you want to add, as shown in the following figure.
8. If the index is unique, select the Unique check box.

   Do not check the box for nonunique tables.

9. Click OK to return to the Warehouse Designer.

   The new table is automatically added to the repository. Save changes before exiting PowerCenter Designer.