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

Configuring the Database Parameter for Post-Load Processing

You must configure your database parameter for your target data warehouse database system in the M_PLP_SESS_PAR_FILE_GENERATE mapping in the Configuration for Post Load Processing folder.

To configure the database parameter for the target data warehouse database system

1. Start the Designer.
2. Connect to your repository.
3. Open the Configuration for Post Load Processing folder.
4. Open the M_PLP_SESS_PAR_FILE_GENERATE mapping with Mapping Designer.
5. Double-click the EXP_PARAMETERS Expression transformation to open the Edit Transformation box.
6. Click the Ports tab.
7. Set the expression for the port DATABASE_NAME_VAR with the database value you are using for your target data warehouse database system:
   • If the source system database is Oracle, set the value to ORACLE.
   • If DB2, set the value to DB2.
   • If MS SQL SERVER, set the value to MSSQL.
   • If Teradata, set the value to TERADATA
8. Validate the mapping and save the repository.