Loading D&B Data on Oracle

Oracle installations require you to run SQLLOADER control files. You need the following control files:

• s_dnb_update.ctl (for loading Marketing Data file into S_DNB_UPDATE table)

• s_dnb_sic.ctl (required only if loading the SIC file)

• s_dnb_mrc.ctl (required only if loading the MRC file)

Note: This procedure assumes that you understand how to run SQLLOADER. SQLLOADER is described in the Oracle documentation.

To load D&B data if you are using Oracle

1. Verify that the column order of your D&B file matches the column requirements in the CTL file before running the loading script.

2. Truncate the appropriate staging tables.

   For more information, see the table that lists D&B Data to Delete and Load in the topic Loading D&B Data.

   To optimize loading performance, drop all indexes on the S_DNB_UPDATE table and re-create them after the scripts have completed by using Siebel utilities ddlexp (to back up the indexes before dropping) and ddlimp (to re-create them).

3. Modify the SQL file as appropriate for:

   • The name of your database

   • The D&B filename and directory location

   • The database table owner

   • The user ID and password (with loading privileges) that you are using to load the data

4. Run SQLLOADER.