Bookshelf Home | Contents | Index | PDF     

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

Types of Extension Columns

Each fact and dimension table has a unique set of extension columns. The following sections outline the types of extension columns for each type of table.

There are two types of dimension tables. Table 26 provides descriptions of the types of extension columns present in both types of dimension tables. The only difference between the two types is that one type of dimension table has more columns than the other.

Table 26. Extension Columns in Dimension Tables
Type of Extension Column
Description
Number of Columns

Code

You can use these columns to store codes.

3 to 10

Code Name

You can use these columns to store code names. Code names are looked up to decipher cryptic codes.

3 to 10

Text

You can use these columns to store text. This is a pass-through column.

3 to 10

Fact tables generally have more types of extension columns than dimension tables. This is due to the nature of a star schema. Table 27 provides descriptions of the extension columns present in the two types of fact tables. The only difference between the two types is that one type of fact table has more columns than the other.

Table 27. Extension Columns in Fact Tables
Type of Extension Column
Description
Number of Columns

Code

You can use these columns to store codes.

3

Code Name

You can use these columns to store code names. Code names are looked up to decipher cryptic codes.

3

Text

You can use these columns to store text. This is a pass-through column.

3 or 8

Date Key

You can use these columns to store date keys. The ADI transforms any dates into Julian dates.

3

Amount

You can use these columns to store monetary values. Amounts come in triplets—document, local, and group currencies. For information on the three types of currencies, see About Document, Local, and Group Currencies.

9 (3 Document, 3 Group, 3 Local)

Quantity

You can use these columns to store units.

3 or 6

Dimension Key

You can use these columns to store dimension keys. You can use this to join the fact table to a new dimension table.

3 or 5

In the following sections, you learn how to incorporate attributes, metrics, and dates into fact, dimension, and class tables.

    
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide