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

Table Formats

You can create additional tables in Siebel Customer-Centric Enterprise Warehouse to meet your business requirements. This section lists the specific formats for various tables that are commonly used standards.

Although there are exceptions to the rules, these are the formats you need to follow when creating new tables. All tables, with the exception of new staging tables, need to be created in the Siebel Business Analytics folder in the PowerCenter repository. Only staging tables are created within the prepackaged, source-specific configuration folders, such as Configuration for Oracle 11i and Configuration for PeopleSoft.

The following topics discuss additional table formats you can create in Siebel Customer-Centric Enterprise Warehouse. They describe how to create an entirely new table, as well as how to make a new table using a copy of an existing table:

• Fact Table Format
• Load Control Table Format for Fact Tables
• Dimension Table Format
• Load Control Table Format for Dimension Tables
• Aggregate Table Format
• Incremental Table Format
• Staging Table Format

Each of the table types in Siebel Customer-Centric Enterprise Warehouse has a specific format and naming convention that must be followed to create tables.

You can also create Profile tables with additional table formats. Profile tables are covered separately in the topic Creating a Profile Table Using Domain Values.