Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Storing, Extracting, and Loading Additional Data > Overview of Storing, Extracting, and Loading Additional Data >

About Classifying Additional Data

There are three types of data that you might want to store in the Siebel Customer-Centric Enterprise Warehouse:

• Attributes. Attributes include descriptive data that allow you to look at metrics under different circumstances. Examples of attributes are product name, product description, and sales order number.
• Amounts and Quantities. Amounts and quantities are two types of metrics, which are sometimes referred to as facts. Amounts are monetary values, such as costs, revenues, profits, and so on. Quantities are counts of items, such as the number of sales orders, number of products sold, and number of backlogged sales orders.
• Dates. Dates are self-explanatory.

Depending on the type of data that you want to store in the data warehouse, you may choose a particular type of table, as well as an extension column with a particular data type. Siebel Customer-Centric Enterprise Warehouse prepackages extension columns in fact tables, dimension tables, and class tables, where each type of table contains different types of extension columns.

The following sections suggest the types of tables and columns to use when storing particular types of data in your data warehouse.