1 year ago

#296523

test-img

Jomy

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 modeling (Dimension & Fact tables). How will I build a DIM & FACT table from Data Vault model (hub, link, sat, msat)? What all columns go into DIM & FACT tables? Please share your thoughts on this.

data-modeling

dimensions

dimensional-modeling

data-vault

0 Answers

Your Answer

Accepted video resources