Bookshelf Home | Contents | Index | PDF |
Siebel Data Quality Administration Guide > Sample Configuration and Script Files > Sample SQL Scripts > IDS_IDT_CONTACT_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 CONTACTS_SNAPSHOT_VIEW; CREATE MATERIALIZED VIEW CONTACTS_SNAPSHOT_VIEW AS T2.FST_NAME || ' ' || LAST_NAME NAME, DECODE(T2.PR_PER_ADDR_ID,T3.ROW_ID,'Y','N') PRIMARY_FLAG, T2.SOC_SECURITY_NUM SocialSecurityNumber, FLOOR((ROWNUM-1)/&BATCHSIZE)+1 BATCH_NUM T1.ADDR_PER_ID = T3.ROW_ID AND -- OR (T1.ADDR_PER_ID IS NULL)) Do we need contacts with no address? --Comment the following line for Multiple address match option -- T2.PR_PER_ADDR_ID = T3.ROW_ID (+) AND T2.PR_DEPT_OU_ID = T4.PAR_ROW_ID (+) SELECT '============================================================================' || CHR(10) || ' REPORT ON CONTACTS SNAPSHOT' || CHR(10) || '============================================================================' || CHR(10) " " |
Siebel Data Quality Administration Guide | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |