Sample SQL Scripts

This topic provides examples of the SQL scripts that are used for incremental data load.

• IDS_IDT_ACCOUNT_STG.SQL

• IDS_IDT_CONTACT_STG.SQL

• IDS_IDT_PROSPECT_STG.SQL

• IDS_IDT_CURRENT_BATCH.SQL

• IDS_IDT_CURRENT_BATCH_ACCOUNT.SQL

• IDS_IDT_CURRENT_BATCH_CONTACT.SQL

• IDS_IDT_CURRENT_BATCH_PROSPECT.SQL

• IDS_IDT_LOAD_ANY_ENTITY.CMD (Windows)

• IDS_IDT_LOAD_ANY_ENTITY.sh (UNIX)