Source Data History (SDH) Tables

Source data history (SDH) tables hold incoming, best version, and historical data records. They have the following characteristics:

• Provide a mechanism to trace the life-cycle properties of records.

• Help maintain versioning of the base table records.

• Provide a staging area for data-quality processes before records move into base tables.

• Store the versioning for records going through the merge and unmerge process.

Note: External systems must integrate with these SDH tables. Oracle Customer Hub (UCM) integration revolves around integrating these SDH tables.