Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Configuring Extracts >

Extracting Additional Data

You can configure extract mappings and mapplets in the Siebel Customer-Centric Enterprise Warehouse to accommodate additional source data. For example, if your business divides customer information into separate tables based on region, then you would have to set up the extract mapping to include data from both tables.

You can modify extract mappings so that new data is loaded into extension columns that act as placeholders for additional data. Extension columns make it possible to extend any fact or dimension table without changing the schematic structure of the Siebel Customer-Centric Enterprise Warehouse or making modifications to the load mapping, as the load mappings already include the extension columns. Keeping the data model intact allows you to implement upgrades without losing any customization.

Extracting New Data Using an Existing Source Table

Extract mappings generally consist of a source table or Business Component, an Expression transformation, and a staging table. If you want to extract new data using the existing mapping, you have to modify the extract mapping to include the new data by performing the following tasks:

To modify an existing mapping to include new data

1. Modify the existing Business Component to extract information from the source, and add it to an appropriate extension column.

   TIP:   You can perform calculation transformations in the Business Component mapplet of the extract mapping or in the Source Adapter mapplet of the load mapping. However, do not use performance-expensive calculations in the extract that could tie up your source transaction system. For these types of calculations, it is recommended that you perform them in the Source Adapter mapplet in the load mapping.

2. Modify the Expression transformation to perform any necessary transformations.
3. Connect all input and output ports within the extract mapping so that the data moves from the source or Business Component to the Expression transformation, and finally to the staging table's appropriate extension column.

You have to determine which type of extension column to map the data to in the staging table.

Extracting Data from a New Source Table

Business Components are packaged as mapplets, which reside in source-specific folders within the repository. Business Components are used to extract data from the source system. You can configure these mapplets to perform the following:

• Extract data from a new source table
• Set incremental extraction logic

The following procedure contains instructions for adding a new table to the Business Component. The procedure includes adding a new source definition, connecting the ports to the Source Qualifier, editing the Source Qualifier, connecting the ports to the Output transformation, and editing the Output transformation.

To add a new source table to an existing Business Component mapplet

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Open Mapplet Designer tool.
3. Drag the Business Component mapplet into Mapplet Designer to view the transformations that comprise the Business Component.
4. Expand the Sources folder, and copy a source table into the mapplet by dragging and dropping the table into Mapplet Designer.
5. Connect the applicable ports from the new source definition to the Source Qualifier by clicking on the port in the new source table and dragging it to the connecting port in the Source Qualifier.
6. Double-click the Source Qualifier to open the Edit Transformations box.

   In the Ports tab, make any changes to the new ports for data type, precision, scale, or all these values, as necessary.

7. Connect the applicable ports from the Source Qualifier to the Mapplet Output transformation (MAPO).

   NOTE:  In some cases, the Business Component contains an Expression transformation between the Source Qualifier and the MAPO.

8. In the Properties tab, make changes to the SQL statement as necessary.
9. Validate and save your changes to the repository.