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
0
votes
1 answer

How to store a not partly unique primary key in a data vault?

I've got a problem with trying to transfer a data model to a data vault. I've tried a lot already but cannot figure out the correct way of identifying the hubs, links and satellites for this part of the diagram. What is shown is a employee that…
SomeDutchGuy
  • 2,249
  • 4
  • 16
  • 42
0
votes
1 answer

What is the Best Practice Approach To Handle Driving Key Relationships in Data Vault v2.0.2

We are in the process of implementing a new data store using Data Vault methodology in the Snowflake database. Our intention is to hold to the latest standards and best practices as far as we can e.g. an insert only approach and attempting to avoid…
BarneyL
  • 1,332
  • 8
  • 15
0
votes
1 answer

Is it mandatory that using Hub keys it should be able to uniquely indentify a record in satellite

I am a newbie in data vault modelling, I could not find a satisfying answer for the below query, pls help. In Data Vault modelling, whether the below statement should met? If yes, should it be met 100%? "The BKs in the Hub or Hubs should be such…
user957183
  • 417
  • 3
  • 10
  • 20
0
votes
0 answers

Implement an update algorithm for Data Vault in PL / SQL

I'm currently working on modeling a data warehouse using Data Vault modeling. My problem is the following: I want to define for each satellite the last state according to a business key. Here are the elements and the algorithm that I want to put in…
Guillaume
  • 3
  • 3
0
votes
1 answer

Best Practices for Vaulting EAV

One of the source systems I am trying to vault holds a set of two tables that operate as entity attribute value tables. I am wondering what are the best methods people have used to move these tables into a Data Vault 2.0 model.
J. Bartels
  • 1
  • 1
0
votes
1 answer

How to implement a Role Play Dimension into Data Vault

I have a data model based on a star schema. It stores three date elements. I integrated them into one role play dimension to avoid redundant dates. I would like to store my data into a data vault model in the core DWH and show the star schema as a…
yellow days
  • 1,053
  • 2
  • 9
  • 11
0
votes
1 answer

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…
Befo
  • 11
  • 2
0
votes
2 answers

Using Datavault modelling before the use of Kimball methodology for a datawarehouse

In a data ware house project why do we need to use DataVault modelling before transfer the data in data marts(which use Kimball methodology) from landing / staging area databases?. ie Why can't we use the Kimball methodology to transfer the data…
Explorer
  • 295
  • 1
  • 12
0
votes
1 answer

Data Vault 2.0 - why do we need business vault when we have information marts?

What's the purpose of having a business vault when we can apply business rules while building information marts?
Fictional
  • 59
  • 1
  • 5
0
votes
1 answer

Should I add hashkey in staging area or in ETL from staging area to DWH?

We plan the EDW in the following structure. Operational System --> Staging Area --> EDW (data vault) According to data vault law it is required to hash the business key. Should I implement the hashing in the Staging area or in the ETL(from staging…
Hello lad
  • 17,344
  • 46
  • 127
  • 200
0
votes
1 answer

Data vault for NoSQL

I have quite a lot of data in JSON format and I would like to build a data warehouse out of them. Since there is a large amount of data and they are semi-structured, I thought to use a document NoSQL database, e.g. MongoDB. Regarding modelling the…
etzourid
  • 331
  • 4
  • 18
-1
votes
1 answer

Data Vault 2.0 - What is a multi-active satellite?

My question is about the Data Vault 2.0 methodology for data modeling. -------What is a multi-active satellite?------- I could not find a very basic definition with a very basic example for it in any book or website.
jeppoo1
  • 650
  • 1
  • 10
  • 23
-1
votes
1 answer

Data Vault relation among links and hubs

I have the following dimensions: And I created the following relationship between these two links in my data vault scheme. Is it correct? Is it allowed to connect links directly without hubs? If no how can I do it? Can shipname or shipaddrees be…
phpdev
  • 511
  • 4
  • 22
1 2 3 4
5