python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - data-vault

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 s...
test-img

Jomy

data-modeling

dimensions

dimensional-modeling

data-vault

Votes: 0

Answers: 0

How can I monitor a CSV file in Azure blob store for newly added records, similar to unix "tail -f"?

Context: I am an information architect (not a data engineer, was once a Unix and Oracle developer), so my technical knowledge in Azure is limited to browsing Microsoft documentation. The context of t...
test-img

Russell Searle

azure-blob-storage

microsoft-dynamics

data-warehouse

tail

data-vault

Votes: 0

Answers: 1

Latest Answer

One possible solution to your problem is to store each new CSV record as a separate blob. You will then be able to use Azure Event Grid to raise events when a new blob is created in Blob Storage i.e. ...
test-img

Gaurav Mantri

SCD Type-2 Using INSERT strategy

I am using Data vault 2.0 model. Here we are not supposed to use UPDATE in a table. Normally in RDBMS, we implement SCD-2 using UPDATE & INSERT strategy. But in my case, I can use only INSER strat...
test-img

Jomy

sql

snowflake-cloud-data-platform

scd2

data-vault

Votes: 0

Answers: 1

Latest Answer

Your satellite key needs to consist out of the Hash Key + the Load Date Timestamp. Each individual version will then have a new primary key and thus can be inserted into the satellite. By querying the...
test-img

Marcel

Posts

Questions

Blogs

Jobs