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