Siebel Data Quality Administration Guide > Sample Configuration and Script Files > Sample SQL Scripts >

IDS_IDT_CURRENT_BATCH_CONTACT.SQL

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

CREATE OR REPLACE VIEW INIT_LOAD_ALL_CONTACTS AS

SELECT

   CONTACT_ID,

   NAME,

   MIDDLE_NAME,

   ADDRESS_ID,

   CITY,

   COUNTRY,

   POSTAL_CODE,

   STATE,

   STREETADDRESS,

   ADDRESS_LINE2,

   PRIMARY_FLAG,

   BirthDate,

   CellularPhone,

   EmailAddress,

   HomePhone,

   SocialSecurityNumber,

   WorkPhone,

   ACCOUNT

FROM

   CONTACTS_SNAPSHOT_VIEW

WHERE

   BATCH_NUM=

(SELECT BATCH_NUM FROM IDS_IDT_CURRENT_BATCH)

/