Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >

About Analyzing Data Warehouse Tables for Optimal ETL Performance

The Siebel Customer-Centric Enterprise Warehouse loads data into the data warehouse tables through a series of extraction, transformation and loading (ETL) steps. The set of data warehouse tables depends on the application and the data source adapter that the you have purchased.

For the ETL process to work efficiently, you need to analyze the target database tables and compute statistics on them during the ETL process. This is a critical step to avoid significant delays in the ETL process.

The preconfigured workflows you see in the Siebel Customer-Centric Enterprise Warehouse depends on the application and the data source adapter that you have purchased. Each workflow contains a set of worklets, and each worklet contains a set of sessions, each of which loads one or more target tables. These target database tables need to be analyzed for the database to use the most efficient plan for running a SQL statement that is generated by the ETL process.