DataVault4Coalesce - Data Vault Implementation

VALIDATING YOUR STAGES To ensure that everything is functioning correctly and your stages are properly set up, click the “Run All” button located in the upper-right corner of the interface. This action validates the configurations and processes all the stages. After running, double-click on the stage “ DVSTG_Customer ” to inspect its details. You should notice that two new columns, LDTS (Load Date Timestamp) and RSRC (Record Source), have been automatically added. These columns are crucial for tracking when each record was loaded and identifying its source system. To verify that the data has been loaded correctly, click the “Fetch Data” button. This will display the data within the stage, allowing you to confirm that all records are present and correctly formatted. ADDING HASH KEYS TO THE STAGE Continuing with your Data Vault development, the next step is to add hash keys in the stage. Hash keys are essential for uniquely identifying records and linking data across different tables.

1. Locate the C_Custkey column in the “ DVSTG_Customer ” stage.

2. Right-click on the C_Custkey column and select “Generate Hash Column” from the context menu.

3. A new hash key column will appear at the bottom of the column list. Rename this column appropriately. For instance, HK_Customer_H to reflect its purpose.

7/16

DATAVAULT4COALESCE: HOW TO ACCELERATE YOUR DATA VAULT IMPLEMENTATION © SCALEFREE INTERNATIONAL GMBH 2025

Powered by