Siebel Data Warehouse Installation and Administration Guide > Setting System Preferences and Using Exception Reports >

Using ETL Alignment Version System Preferences

Seed data needs to be updated in certain Lists of Values (LOV) to make sure that the ETL process correctly populates the alignment type and product category relationships in the Siebel Data Warehouse.

Changing the ETL Alignment Version System Preferences

These preferences are used by the Siebel Life Sciences operational database to control loading of changes in assignment rules in Siebel Assignment Manager.

To change the alignment version system preferences

  1. Using a standard text editor, open the SysPrefDelta.dat file.
  2. Change the Y/N value to the desired setting:
    • If you want to make changes to the existing alignment, set Alignment Version to N.
    • If you want to create a new alignment version, set Alignment Version to Y.
  3. Save the file.
  4. Run the full or incremental ETL batch as you would normally.

    The changes will occur during the loading process as a part of pre-request loading; alignment loading will be processed according to the setting.


 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004