Bookshelf Home | Contents | Index | Search | PDF

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 OLTP

---

• 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 OLTP

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.
5. Verify if the related table is registered in the DAC. If an entry is not there, you need to create a new record for the table and assign it an image suffix. If the table is registered, make sure there is an image suffix assigned for this table.
6. If an image suffix does not exist for the table under consideration, assign one. The image suffix should be three characters long. The recommended naming convention is to start with C. For example, use C1, C2, CA1, CA2, and so on. Make sure this suffix is not used by other tables. The DAC client does not validate this information when entering data.
7. Create Image tables in the OLTP. Right-click on the table record in the DAC client, and choose Generate Change Capture Scripts. This will assist you with creating the image tables, necessary indices, and triggers if you plan on tracking deletes on the OLTP database. Execute these scripts on the OLTP.
8. For the task that is created for the extract process set the Build Image flag to True and select the new table as an auxiliary table.

Bookshelf Home | Contents | Index | Search | PDF