1. Applications Administration Guide
  2. Overview of the Update Process

Overview of the Update Process

This topic outlines the process of loading D&B data from the staging tables to the D&B Account tables through to updating the Siebel account tables.

This process recommends using the D&B Update Manager MultiTask server component to run server component tasks in parallel. However, use of the single task D&B Update Manager (D&B) and D&B Update Manager (Siebel) server components is also documented in this chapter.

  1. Make sure you have loaded the D&B data into the staging tables.

    For more information, see Loading D&B Data and Loading D&B Data Using Sample Scripts.

  2. Update the D&B Account tables with data from the staging tables:

    1. To optimize performance, you can perform one of the following steps:

      • For first time data loading when there are no D&B records in the Siebel database, drop the indexes on the following D&B Account tables: S_DNB_ORG, S_DNB_ORG_SIC, S_DNB_CON_MRC, and S_PRSP_CONTACT.

      • For subsequent updates, drop the indexes on the S_DNB_ORG table only, all except for the indexes S_DNB_ORG_U1 (DUNS_NUM), S_DNB_ORG_P1 (ROW_ID), and S_DNB_ORG_M01 (the clustered index) on this table.

    2. Create a search specification on the D-U-N-S number to set up your preferred batch sizes and determine the corresponding D-U-N-S number ranges for each batch for loading the data from the staging tables to the D&B Account tables.

    3. Run concurrent D&B Update Manager (D&B) server tasks by running the D&B Update Manager MultiTask server component.

      For more information, see Multiple Task Siebel Update Server Component and Running the Siebel Update Server Components.

    4. Continue to run the concurrent D&B Update Manager (D&B) server tasks until all data is loaded into the D&B Account tables.

    5. If you dropped indexes on the D&B Account tables, then re-create them by using Siebel utilities ddlexp (to back up the indexes before dropping) and ddlimp (to re-create them).

  3. Update the Siebel Account tables from the D&B Account tables for accounts with matching D-U-N-S numbers by executing concurrent D&B Update Manager (Siebel) server tasks using the D&B Update Manager MultiTask server component.

    For more information, see Multiple D&B Update Manager (Siebel) Processes and Running the Siebel Update Server Components.