Bookshelf Home | Contents | Index | PDF |
Siebel Data Quality Administration Guide > Sample Configuration and Script Files > Sample SQL Scripts > IDS_IDT_ACCOUNT_STG.SQLThe following sample SQL script can be used for incremental data load. '============================================================================' ' Need to change TBLO before executing the scripts on target database. ' '============================================================================' DROP MATERIALIZED VIEW ACCOUNTS_SNAPSHOT_VIEW; CREATE MATERIALIZED VIEW ACCOUNTS_SNAPSHOT_VIEW AS DECODE(T2.PR_BL_ADDR_ID,T3.ROW_ID,'Y','N') PRIMARY_FLAG, FLOOR((ROWNUM-1)/&BATCH_SIZE)+1 BATCH_NUM -- Comment the following line for Multiple address match option -- AND T2.PR_BL_ADDR_ID=T3.ROW_ID SELECT '============================================================================' || CHR(10) || ' REPORT ON ACCOUNTS SNAPSHOT' || CHR(10) || '============================================================================' || CHR(10) " " |
Siebel Data Quality Administration Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |