A crucial component of any Data Vault is making sure there is a way to identify when data is no longer current. For data sources without a form of inbuilt change tracking, Record Tracking Satellites are going to be required. A Record Tracking Satellite compares incoming business keys with existing business keys. Any differences are recorded with a timestamp and a flag noting the change.

By analyzing the Record Tracking Satellite it is possible to identify when a business key is no longer in use and to exclude it from reports or analytics. WhereScape users can automate the creation of Record Tracking Satellites saving themselves hours of work and increasing the integrity of their Data Vault. The linked documentation will guide users through installation, and modification, of the WhereScape Record Tracking Solution.

To view the full document, please click here