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)
/