The Data Vault Handbook - Concepts and Applications

for troubleshooting, ensuring that every piece of data can be traced back to its originating source.

The Record Source is a key technical attribute that supports debugging pro- cesses by providing a direct reference to the origin of the data. While it helps ensure data traceability back to the original source systems, its primary val- ue lies in assisting technical teams in identifying and resolving issues during data loading and processing. To make the most of the Record Source attri- bute, it is advisable to use the most detailed level of granularity possible.

Less detailed Record Source SALESFORCE

More detailed Record Source (recommended) SALESFORCE/Partners/2024-01-01T07:00:00

LOAD DATE TIMESTAMP

The Load Date Timestamp is a system-generated and maintained attribute that records the exact timestamp when a business key first enters the data platform. This technical timestamp has no business meaning and is used purely for technical purposes. In this sense, the field is crucial for tracking the timing of data ingestion and is consistent across all data loaded within the same batch. By ensuring that all records in a batch share the same Load Date Timestamp, the system enables traceability, making it easier to identify and resolve any technical issues or errors that may have occurred during the loading process.