settingsLogin | Registersettings
Scalefree
Show Menu

How to model a staging table with history data in to a Raw Data Vault?

0 votes
Hi. In my staging model I have USERS that can be in one or many PROGRAMS and can receive communications from programs via one or many CHANNELS (e.g. text messages, emails). There is USERPROGRAM table that stores data from the many-to-many relationship between USER and PROGRAM. There is also a PROGRAMSUBSCRIPTION table that stores the most recent status of a User subscription (actively receiving messages vs not receiving messages) to a Channel of a Program. Finally, there is a PROGRAMSUBSCRIPTIONHISTORY table that gets a new row every time users change the status of their subscriptions to a Channel in a Program from "active" to "inactive". So far, although it could be wrong, I have the following for my Data Vault model:

1. USERS becomes a Hub_User
2. PROGRAMS becomes a Hub_Program
3. USERPROGRAM becomes a Link between the Hub_User and the Hub_Program

How do I model the PROGRAMSUBSCRIPTION and, more importantly, the PROGRAMSUBSCRIPTIONHISTORY tables?

Thanks
asked Oct 22, 2017 in Modelling by cesar-vinas (120 points)

Please log in or register to answer this question.

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
    ...