- 4
- 52 968
IT and Analytics
Приєднався 24 лип 2021
First, Second and Third Normal Form (Normalization and Denormalization)
First, Second and Third Normal Form (Normalization and Denormalization)
Переглядів: 281
Відео
Differences between Data Vault&3NF&Dimensional Modeling
Переглядів 2,1 тис.2 роки тому
The video describes the differences between Data Vault, 3NF and Dimensional Modeling. To access the whole training please use the following address. www.udemy.com/course/modeling-data-warehouse-with-data-vault-for-beginners/?referralCode=0A6C1965C16C5DD563EB
What is Data Vault?
Переглядів 3,8 тис.3 роки тому
The video provides a short overview of Data Vault 2.0. To access the whole training please use the following address. www.udemy.com/course/modeling-data-warehouse-with-data-vault-for-beginners/?referralCode=0A6C1965C16C5DD563EB
How to create a Data Vault Model from scratch
Переглядів 47 тис.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/course/modeling-data-warehouse-with-data-vault-for-beginners/?referralCode=0A6C1965C16C5DD563EB
Thank you for a very detailed explanation. My question is why we need hash keys? Couldn't we just use the Business keys instead?
Thank you!
thanks!!
Thanks, quite a nice explanation
Good one
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?
A very good explanation, thank you so much!
Turk musun? :)
Well Done
Wow.. so nicely explained
Clearly explained with pros and cons
Very good explanation with a simple example
Absolutely useless, containing lot of redundant words about nothing. And no real explanation. Also a title doesn't reflect real topic of the video - there's no comparison between data modelling
Really well done please create more content
good explanation
bu aksan cok tanidik geliyor :)
Hello, what is the course name? I am looking to prepare for data vault
where can I create that type of diagram of data vault ? I mean I need website name.
Thank you. Very helpful.
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..
Thank you
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
Excellent video !! Thanks.
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
Absolutely brilliant explanation. Thank you very much
Very useFull, thank you
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.
Very nice!
I WATCHED YOUR DV COURSE ON UDEMY. IT'S PRETTY AMAZING. THANKS FOR THE COURSE
Thanks a lot Deepak, I am happy that it was helpful.
Great introduction to Data Vault modelling
Thanks for usefull information.
This is a great video. Thanks.
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
Nice, straightforward explanation. Thank you
Thanks. This gives better understanding at high level DV
Thank you...This solidified my understanding