Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Integrating Additional Data > Table Formats >
Load Control Table Format for Dimension Tables
The first key is the current key, which points to the surrogate key in the dimension IA table. The naming convention for load control tables is OD_[SUBJECT], for example, OD_GL_ACCOUNTS.
The following is the order of the columns, data type, and precision for load control tables for dimension tables:
- Current key (CURR_KEY). The data type for the current key is decimal (15, 0).
- Dimension ID keys. The data type for dimension ID keys corresponding with the IA dimension table is varchar (80).
- Date. The data type of date columns is datetime (26, 6) for SQL Server; date (26,6) for Oracle; and timestamp (26,6) for DB2, with a suffix of DT (for example, CREATED_ON_DT). This column corresponds to the *_DK columns in IA fact tables.
- Other attributes. The data type, length and precision is as found in the corresponding dimension table (IA table).
- Hierarchy columns. The data type for codes is varchar (30,0) and for name the data type is varchar (254). The sequential number of the hierarchy column matches those code or name pairs found in the IA dimension table.
- Code and Description columns. The data type for codes is varchar (30) and for descriptions the data type is varchar (254). The code-name pairs are found in the corresponding IA dimension tables.
- Extension columns. Extension columns corresponds with those found in the IA dimension table.
- Control columns. The data types correspond with those control columns found in the dimension table, including IA_COPYRIGHT and a composite primary key composed of the KEY_ID, SOURCE_ID, and SRC_EFF_FROM_DT. IA_INSERT_DT and IA_UPDATE_DT are dependent on the database; datetime (26, 6) for SQL Server; date (26,6) for Oracle; and timestamp (26,6) for DB2.
NOTE: The SRC_EFF_FROM_DT column is not available in all dimension tables.