Bookshelf Home | Contents | Index | PDF |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Contact Center Analytics > About the Dimension Key Resolution Process for Universal SourceDimension keys uniquely identify each record in a dimension table. The purpose of dimension keys is to relate one dimension table record to a fact table record. Thus, the dimension key must be stored in both the dimension table and the fact table and resolve using the dimension table's For universal business adapters, users supply the dimension KEY_ID and SOURCE_ID column values through a flat file interface. The same values for KEY_ID and SOURCE_ID are expected in both the dimension and fact business adapters so that the correct dimension key is resolved and loaded into its fact table. The dimension key resolution process entails two steps:
The following sections describe these two steps in more detail by taking the example of one fact table ( |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide |