Data Quality Guide for Oracle Customer Hub > Configuring Data Quality with Oracle Data Quality Servers > Sample SQL Scripts >
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)
/
|