Search code examples
data-warehousedata-vault

Transaction Data in Data Vault Model

I'm coding a data warehouse in data vault model. But actually I'm not sure how to work with transaction data. I have the following attributes 

Service
Time(based on minutes)
Status

I have a hub table for Service, a hub table for Status and a hub table for Time, but it's not based on minutes.

The question is? Are the transaction data link tables? How would/do you design this? thanks for your comments

Solution

  • If I have understood your question correctlly, below is the structure of the hubs :

    HUB Service (Hub_Service_HKEY >PK)

    HUB Status(HUB_Status_HKEY ->PK)

    HUB Time(HUB_Time_HKEY ->PK) and Satellite (HUB_Time_HKEY(FK),Year,month,day,hour)

    Then structure for transaction LINK would be TXLNK_SST(TX_LNK_HKEY(PK),HUB_Time_HKEY(FK),HUB_Status_HKEY(FK),Hub_Service_HKEY(FK), Minute_ID, Some_other_fileds_if_any *) to store transaction at grain minute.

    * -> Since transaction link does not store history so other attributes should be stored in transaction link itself.