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 FlippingBook