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