DataVault4Coalesce - Data Vault Implementation

5. HUBS REPRESENTING CORE BUSINESS ENTITIES

After creating a Data Vault Stage, we have everything to populate the first real Data Vault entity. This section will show how to create a Hub with Datavault4Coalesce, based on the previously created “DVSTG_CUSTOMER”.

To start, jump back into the column overview of “DVSTG_CUSTOMER”. Now select all columns that are needed for a Customer Hub:

— The Hub Hashkey, HK_CUSTOMER_H

— The Business Key, C_CUSTKEY

— The Load Date Timestamp, LDTS

— The Record Source, RSRC

11/16

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

Powered by