Siebel Data Warehouse Installation and Administration Guide > Customizing the Siebel Data Warehouse > Customization Steps for Siebel Data >

Adding a Column from a Related Source Table in the Siebel Transactional Database

• Adding ABC in W_PERSON_D because it is not in the supplied model. The value of ABC is sourced from S_CONTACT_X, which is not the main source table for W_PERSON_D.
• Adding measure XYZ in W_ORDERITEM_F because it is not in the supplied model. The value of XYZ comes from S_DOC_ORDER, which is not the main source table for W_ORDERITEM_F.

To add a column from a related source table in the Siebel transactional database

1. Choose one of the following options:
   • Use predefined columns in an existing extension table
   • Create a new extension table with appropriate columns.
2. Create new mappings and workflows (SDE and SIL) to load the extension table column based on the provided templates. The related table should be joined in the Source Qualifier's SQL. Even though additional information is being extracted from a related table in the SQL override, always use the view created on the base table to extract information.
3. If necessary (for the new table), write the auxiliary change capture mappings so that whenever a row changes in the source table for the new column, the corresponding row in the main table is also marked changed, by inserting rows in the Incremental Row Image table.
4. Create a new workflow for the new map and register the task in the DAC repository. Create the dependencies.