Multiple D&B Update Manager (D&B) Processes with First Time Data Loading

The first time you load D&B data when there are no D&B records in the Siebel database, you can use a special SQL file (dnbinitial.sql) which is optimized to load only inserts. Consequently, data is loaded faster than when you use the dnbmaps.tsq file.

To use the dnbinitial.sql file, set the server component parameter DNBConfigFile to dnbinitial.sql. For examples, see Running the Siebel Update Server Components.

For subsequent updates, the DNBConfigFile is set to dnbmaps.tsq.

Note: The dnbinitial.sql file assumes that you dropped the indexes on the D&B Account tables when loading data. For more information, see Loading D&B Data Using Sample Scripts.