Installation and Configuration Guide

Back Next

Database Objects

Identity Resolution

categorizes the database objects into the following logical groups:

Source Database: A source database contains the user data in the User Source Tables (UST).
Identity Resolution
can access the USTs by using a user ID that has select privilege on the USTs.; Identity Resolution
creates fuzzy indexes on the USTs. Use triggers to synchronize the indexes with the UST updates. The triggers store information about the UST rows that you updated, deleted, or added in a transaction table. The transaction table is part of the source database schema. The user ID must have the privilege to create triggers on the USTs.
Target Database: A target database contains Identity Tables (IDT) and Identity Indexes (IDX).
Identity Resolution
creates and updates the identity tables and identity indexes by using a user ID that has create privileges.

If you want the IDTs and IDXs to remain in synchronization with the USTs,
Identity Resolution
also creates a two-phase-commit table,
IDS_2PC
, in the target database schema.