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

Configuring the Date Parameters for Parameter Files

If you use Table 11 for the initial run, the PARM_DVALUE_1 parameter has a value of January 01, 2004. If you extract changed data from 2004, then you are extracting the entire data set. If you have older data, change the value of PARM_DVALUE_1 in the format yyyymmddhh24miss.

If you want incremental runs with a two-day window for the first two sessions, you change only the PARM_NVALUE_1 column for the corresponding sessions. If you want incremental runs with a three-day and four-day window for the third and the fourth sessions, you also change the PARM_NVALUE_1 column for the corresponding sessions. When PARM_NVALUE_1 has a nonzero value, PARM_DVALUE_1 is not used. For an example of how your parameter file (file_parameters_psft8.csv) would appear for incremental loads, see Table 12.

To modify the CSV parameter file

1. Navigate to the appropriate CSV parameter file.

   For example, for Oracle 11i navigate to $pmserver\SrcFiles\file_parameters_ora11i.csv. For a list of parameter files, see Table 10.

2. Copy your CSV file to the SRCFiles folder under the PowerCenter Server folder.
3. Open the file using Microsoft WordPad or Notepad.
4. Search for the column labeled PARM_DVALUE_1.
5. Change the default date (197001010000) to the date you require.
6. Change your new date in every session you want to run incrementally.
7. Save your file.