Convert Data Vault model into Dimension Modelling

482 Views Asked by At

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.

0

There are 0 best solutions below