settingsLogin | Registersettings
Scalefree
Show Menu

Load data from SDV to BDV

0 votes
Hello,

My understanding is that Business Data Vault is built from Raw Data Vault i.e ( Hubs, Links and Satellites). I have seen variations or situations, where some BDV tables ( not sure about the usage of these tables at this time) are pulling data from Staging Data Vault i.e Staging tables instead of RDV ?  Is this an acceptable design\ implementation or does this break the fundamentals\best practices of DV and what are the implications ?

In my mind, i was thinking this can lead to creating multiple sources for same information and defeats the purpose of single source of truth.

Thanks Much,

Venkata.
asked Sep 28, 2015 in Business Vault by vkalisetty

1 Answer

0 votes
Dear Venkata,

The Business Data Vault should not be loaded from staging.

You are right with your understanding of the problem (multiple sources). The stage area should be truncated once all data has been sourced.

Hope that helps,

Mike
answered Oct 22, 2015 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
    ...