How to create a Data Vault Model from scratch
HTML-код
- Опубликовано: 23 июл 2021
- The video describes a sample scenario that shows the modeling steps of Data Vault 2.0. To access the whole training please use the following address.
www.udemy.com/course/modeling...
Thanks. This gives better understanding at high level DV
Absolutely brilliant explanation. Thank you very much
Great introduction to Data Vault modelling
Thank you...This solidified my understanding
Very good explanation with a simple example
Nice, straightforward explanation. Thank you
Excellent video !! Thanks.
This is a great video. Thanks.
A very good explanation, thank you so much!
Very useFull, thank you
Wow.. so nicely explained
Thank you. Very helpful.
Really well done please create more content
Very nice!
good explanation
bu aksan cok tanidik geliyor :)
Thank you
Well Done
Great content ! How you migrated 3NF model into Data Vault model with example was amazing ! Why did you stop making further content ?
Remember that in real life settings you do not directly "convert" 3NF to DV or you end up with Source System Data Vault
You need to add a relation describing hub between employee and project which contains the data for which employee works on a specific project. In your case you would have sattelite attached to the link. This is not advised in data vault modelling
Can you please help me with these . Would be great if you can explain with some examples.
1. Why link to link relationship is not recommended in RDV?
2. In BDV bridge table, if we are storing only hash keys( not natural keys), then how in fact/dimension we are going to get natural keys?
where can I create that type of diagram of data vault ? I mean I need website name.
What is the special benefit of Data Vault modeling compared to convention EDW design say Kimball methodology ?
Not creating an intertwined monolithic mess of a data structure, and adding possible support for streaming ETL. However, probably using a Data Mesh is even better as it's much easier to develop and doesn't have the stupid hash keys.
what are the tools available in market to design Data Vault modeling
Erwin. No additional tools are required to design the model. You can design your approach to populate all hubs, links, data in parallel using Airflow. Since all these tables have hash key in it, there is no dependency across them.
Erwin
we use Enterprise architect at out organisation
Turk musun? :)
Data Vault is crap ! It creates a plethora of tables for literally nothing.
It's a non sens to add tables that doesn't bring real business value..
What is the purpose of dividing the model into hubs, links and satellites in the raw vault if at the next layer (business vault) we join again tables to consolidate them ?
For developpers, a data vault model brings more complexity because they will need to do a lot of joinning to create there business agregated tables at the gold layer.
This is EXACTLLY what I confused!! The data vault, this kind of model designing no really avoid the nessary join. Although it seems clear in the staging layer, but in the downstream layer, we still need to use join to derive relative columns..