Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Storing, Extracting, and Loading Additional Data > About Integrating Data from Source Systems Without Prepackaged Business Adapters >

About Extracting Universal Source Data

All universal source data goes through a similar extract mapping that is made up of a flat file template, Source Qualifier, Expression transformation, and staging table. The basic extract mapping for universal source flat files is shown in Figure 45.

Figure 45. Basic Extract Mapping for Universal Source Data

NOTE:  Unlike other adapters, the universal adapter requires values for the DELETE_FLAG, SRC_EFF_FROM_DT, and SRC_EFF_TO_DT.

Each of the extract mapping components is described in the following sections.