Stack Overflow
Stack Overflow

Questions tagged [data-vault]

Data Vault is a methodology and architecture created to address the business of designing, implementing, and managing a data warehouse.

73 questions
2
votes
1 answer

Data Vault Modelling Foreign Keys

I have a question regarding specific data vault modelling. I have a source table which captures call center CALL informations like this: CallId (business key) Date Call_alert Call_acw etc The same source table also has a bunch of foreign keys in…
AMuser
  • 21
  • 1
2
votes
2 answers

Database Architecture, Database Split

I have come across DB architecture which does not feel right to me. It is for a small team of developers... I would appreciate any opinion on this design. This is a simplified description of the system. All of the 3rd NF databases (Client,…
Hooman Bahreini
  • 14,480
  • 11
  • 70
  • 137
2
votes
2 answers

Data Vault Model and Lookup Tables

I am designing a data warehouse that uses the Data Vault model. There is an entity in my data warehouse called Specialty. There is a Lookup Table for these Specialties based on their codes that has a one-to-one mapping from Specialty_CD to…
Nicholas Morrison
  • 31
  • 4
2
votes
1 answer

Data Vault: difference between business, surrogate, retained keys

Surrogate and business keys are mentioned in wikipedia article about Data Vault.enter link description here. Retained keys are mentioned here. According to wikipedia article it is not mandatory to specify the surrogate keys for the hub/satellite or…
Anni
  • 403
  • 7
  • 19
2
votes
2 answers

Data vault model: what are hubs good for?

I was just reading about Data Vault modeling and as far as I understand it, the hub does only contain keys (and the record source). So I was wondering why I should create those hub tables, only to store the record source? Wouldn't it be enough to…
user1261273
2
votes
1 answer

Data Vault - How to select business keys?

If the following three unique attributes arrive from a SalesOrderHeader table in a 3NF model, which one would be the ideal business key for a SalesOrderHeader Hub: SalesOrderID(PK of the original table) SalesOrderNumber PurchaseOrderNumber
Fictional
  • 59
  • 1
  • 5
2
votes
2 answers

Data Vault Hubs from different sources

So I'm trying to implement a data vault. I have some difficulties modeling the hub. I have 2 systems that don't talk to each other. I want to know how to represent the same item from different sources in the hub. In our ordering system, it generates…
Restie
  • 51
  • 4
1
vote
1 answer

Data Vault: Relationship between LINK and SAT on Historical analysis using SQL

In Data Vault Model, we have below tables: Details on how LINKTradeinVehicle and SAT_Order are inserted below: Problem statement: We need to know historically which data between LINK and SAT tables on the basis of LINK's orderkey and vehicleKEY…
Anonymous
  • 11
  • 2
1
vote
0 answers

Is Data Vault modelling appropiate for small teams?

I am building a Data Warehouse from scratch. I am alone in the company, so everything will be implemented by me. My experience with Data Vault is zero. Some information on the net claims that building Data Vault, is not recommended for low-resouce…
greenglas
  • 29
  • 4
1
vote
1 answer

How can I specify what snowflake warehouse to use in dbtvault?

I've specified the warehouse in the profile settings, and have created a profile.yml file that specifies the warehouse, but it keeps giving me this error. I am able to create a staging layer thing. The system is able to connect to snowflake, with…
Scott Wood
  • 1,077
  • 3
  • 18
  • 34
1
vote
0 answers

Convert Data Vault model into Dimension Modelling

In my project I am using Data Vault 2.0 modelling. Now I wanted to build a dimension modelling from the Data Vault model (as per client request). Also we have CDC logic implemented in Data Vault and same has to be implemented in new dimension…
Jomy
  • 87
  • 1
  • 13
1
vote
2 answers

How to insert a row on WHEN MATCHED THEN within a snowflake merge statement if we are trying to fit our data to a data vault model?

I am loading data into Snowflake data vault modeled database. The model work as follows when a field of a row has been updated: Set the load end date of this row as equal to current_timestamp(). Add a the same row one more time with the new values…
alim1990
  • 4,656
  • 12
  • 67
  • 130
1
vote
1 answer

Data vault connect multiple hubs into links, is it the best way using one link, or splitting the links is always a good way in data vault?

I am transforming an existing star schema model into data vault. The main table contains 4 foreign keys coming from 4 different table. In data vault modelling techniques, what is the best practice in modelling such thing: Use one link connecting…
alim1990
  • 4,656
  • 12
  • 67
  • 130
1
vote
1 answer

Reference table to HUB in DataVault 2.p

Can a reference table be collegiated to an HUB ? In all books the reference tables are collegiated only to the Satellite....but why it's not collegiated to a HUB table? Thanks a lot
Francesco Bocchino
  • 11
  • 2
1
vote
1 answer

Modeling a periodic snapshot in data vault?

One of our data sources sends a feed with an aggregate of data per day. A periodic snapshot. For example: shop, day, sales bobs socks, 2019-01-01, 45, bobs socks, 2019-01-02, 50, bobs socks, 2019-01-03, 10, janes coats,2019-01-01,…
James
  • 433
  • 4
  • 14
1
2
3 4 5