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

Adding More Dates to the Data Model

There are a number of dates that are populated when you initialize Siebel Customer-Centric Enterprise Warehouse. For example, purchase orders use an ordered-on-date, a requested-date, a required-on-date, and so on. However, for date types that are not captured by the prepackaged extract and load processes, you can use extension date columns.

To map an additional date column to an extension date column

1. Map the additional date from the source into one of the extension columns in the staging area.

   To do this, you must modify an extract mapping. Within the Business Component:

   1. Include the source table that supplies the date as a source table in the extract mapping.
   2. Map the data from the source table to the Source Qualifier transformation.
   3. Map the data from the Source Qualifier to the Mapplet Output Object (MAPO).
   4. Map the data from the Business Component to the Expression transformation. If your date is not in the proper date format, you can convert it using this Expression transformation.
   5. Map the data from the Expression transformation to the staging table.

      After this is complete, the corresponding load mapping pulls the date data and loads it into the corresponding IA table.

2. You also must modify the front-end schema to report on this date.