settingsLogin | Registersettings
Scalefree
Show Menu

Customer entity: From raw vault to business vault

0 votes
There is a HUB_CUSTOMERS which holds three different satellites with customer data from three different sources. Therefore the RECORD_SOURCE is a part of the composed key in HUB_CUSTOMERS. The sets (satellites) are not disjunctive.

Now we have to prioritize the source data to integrate the customer data in a three-step process to generate a business hub e.g. BHUB_CUSTOMERS (B=Business) which holds the customers and represents our main source table for e.g. DIM_CUSTOMERS in a data mart. By this we create redundancy: HUB_CUSTOMERS and BHUB_CUSTOMERS.

Is this approach okay?
asked Feb 25, 2016 in Modelling by raphael (120 points)

1 Answer

0 votes
Hi Raphael,

first of all, the record source should not be part of the business key. It should be there for debugging purpose only. You can however, add a field to the composite key to reflect the source system.  This has been discussed on p age 124 of our book (Building a Scalable Data Warehouse with Data Vault 2.0).

In the end, the idea is that the Hub integrates the data from your satellites using the business key.

You should consolidate your keys using a same-as-link (page 129).

Hope that helps,

Michael
answered Feb 25, 2016 by molschimke (1,890 points)
Scalefree Scalefree

Upcoming Trainings

  • July 01 to 03 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • August 05 to 07 - Berlin (German) Data Vault 2.0 Boot Camp and Certification

  • September 9 to 13 - Hanover WWDVC EU

  • September 16 to 18 - Brussels (English) Data Vault 2.0 Boot Camp and Certification

  • October 21 to 23 - Hanover (German) Data Vault 2.0 Boot Camp and Certification

  • November 18 to 20 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • December 02 to 04 - Dusseldorf (German) Data Vault 2.0 Boot Camp and Certification

  • December 16 to 18 - Zurich (English) Data Vault 2.0 Boot Camp and Certification

  • Contact us for inhouse training engagements.
    Visual Data Vault: Logical Modelling for Data Vault - Free Download!
    Scalefree
    DataVault.guru is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.
    Permissions beyond the scope of this license are available in our license.

    DataVault.guru | DWH Wiki | Recent questions RSS feed | Imprint | Provided by Michael Olschimke
    ...