Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Planning Your Warehouse Configuration Project > Data Warehouse Configuration Stages >

Configurable Objects in the Extract Mapping

Extract mappings are useful in extracting data from a source system and staging the data in a staging table. Within each extract mapping (with the exception of Universal Source extract mappings), you find the following objects—Business Component mapplet, Expression transformation, and staging table. A mapplet is a reusable object that contains a set of transformations, and it allows you to reuse the transformation instructions in multiple mappings.

You can configure the Business Component mapplet to do any of the following tasks:

• Extract additional data from new or existing source tables.
• Set up an incremental extract.
• Filter the type of records extracted.

NOTE:  Universal Source extract mappings do not contain Business Components. These mappings have a flat file source which requires that most transformations be performed prior to the extract mapping.

You can configure the Expression transformation in the extract mapping to perform the following tasks:

• Set the Key ID for the records.
• Set the Source ID for the records.

The staging table is the target table for the extract mapping, and stores the extracted information.