Data Quality Guide for Oracle Customer Hub > Configuring Data Quality with Oracle Data Quality Servers > Sample SQL Scripts >

IDS_IDT_CURRENT_BATCH_PROSPECT.SQL

The following sample SQL script can be used for incremental data load.

CREATE OR REPLACE VIEW INIT_LOAD_ALL_PROSPECTS AS

SELECT

   ACCOUNT_NAME,

CELLULAR_PHONE,

   CITY,

   COUNTRY,

   EMAIL_ADDRESS,

   NAME,

   HOME_PHONE,

   MIDDLE_NAME,

   POSTAL_CODE,

   SOCIAL_SECURITY_NUMBER,

   STATE,

   STREETADDRESS,

   WORK_PHONE,

   PROSPECT_ID

FROM

   PROSPECTS_SNAPSHOT_VIEW

WHERE

   BATCH_NUM=

(SELECT BATCH_NUM FROM IDS_IDT_CURRENT_BATCH)

/