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

IDS_IDT_CURRENT_BATCH_ACCOUNT.SQL

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

CREATE OR REPLACE VIEW INIT_LOAD_ALL_ACCOUNTS AS

SELECT

   ACCOUNT_ID,

   ACCOUNT_NAME,

   ACCOUNT_ADDR_ID,

   ADDRESS_LINE1,

   ADDRESS_LINE2,

   COUNTRY,

   STATE,

   CITY,

   POSTAL_CODE,

   PRIMARY_FLAG

FROM

   ACCOUNTS_SNAPSHOT_VIEW

WHERE

   BATCH_NUM=

(SELECT BATCH_NUM FROM IDS_IDT_CURRENT_BATCH)

/