How to create a Data Vault Model from scratch

No video

How to create a Data Vault Model from scratch

Рет қаралды 41,597

3 жыл бұрын

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/...

Пікірлер: 32

@M20081986 Жыл бұрын

Great content ! How you migrated 3NF model into Data Vault model with example was amazing ! Why did you stop making further content ?

@rezzuri 5 ай бұрын

Remember that in real life settings you do not directly "convert" 3NF to DV or you end up with Source System Data Vault

@EGlobalKnowledge 6 ай бұрын

Very good explanation with a simple example

@gencayturan7359 Жыл бұрын

bu aksan cok tanidik geliyor :)

@rupanag 5 ай бұрын

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?

@mashagalitskaia8642 5 ай бұрын

A very good explanation, thank you so much!

@top_1_percent Жыл бұрын

Absolutely brilliant explanation. Thank you very much

@isssssam85 Жыл бұрын

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

@helloranjan89 6 ай бұрын

Wow.. so nicely explained

@xDeemanOne 8 ай бұрын

Really well done please create more content

@sinrajnallappan1965 2 жыл бұрын

Thanks. This gives better understanding at high level DV

@phethosilas8781 2 жыл бұрын

Thank you...This solidified my understanding

@mattclark1981 2 жыл бұрын

Nice, straightforward explanation. Thank you

@suhel.choudhury 2 жыл бұрын

Great introduction to Data Vault modelling

@holgerrachut6790 6 ай бұрын

Well Done

@gauravpande602 Жыл бұрын

Excellent video !! Thanks.

@user-yg4cs2uv2y Жыл бұрын

where can I create that type of diagram of data vault ? I mean I need website name.

@jakeo1209 Жыл бұрын

Thank you. Very helpful.

@vinaykumar_cool Жыл бұрын

good explanation

@STEVEN4841 2 жыл бұрын

Very useFull, thank you

@santosx3510 Жыл бұрын

Thank you

@aks541 2 жыл бұрын

What is the special benefit of Data Vault modeling compared to convention EDW design say Kimball methodology ?

@harigabor910 Жыл бұрын

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.

@dsinghr 2 жыл бұрын

This is a great video. Thanks.

@mrvklncr 6 ай бұрын

Turk musun? :)

@Aurum51 2 жыл бұрын

Very nice!

@awesome_harish 2 жыл бұрын

what are the tools available in market to design Data Vault modeling

@dsinghr 2 жыл бұрын

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.

@rakeshporwad01 2 жыл бұрын

Erwin

@isssssam85 Жыл бұрын

we use Enterprise architect at out organisation

@ametdiakhate8126 Жыл бұрын

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.

@nglamont7015 Ай бұрын

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..