00:45 Snowflake Schema is a variation of Star Schema. 01:30 Snowflake scheme is used for normalization in a data model. 02:15 Normalization helps to reduce data redundancy and improve data organization. 03:00 Normalization improves data integrity by reducing duplication and ensuring unique values. 03:45 Government mandates city name changes 04:30 Normalizing in data tables reduces redundancy and simplifies updates 05:15 If you want to change the name of Lucknow, then you only need to update it at one place. 05:58 The snowflake schema has advantages in terms of reducing updation and improving query performance by joining multiple tables.
Presented in a good way easily understandable keep it up and I also do have a question for you " I want to create a snowflake schema of a database which contain different tables. How can I create fact and dimensions tables from them. Is there any rule for creating fact and dimension table or we can create them just by looking at our already created tables in database?" Any volunteer's answer would be appreciated. Thanks
Slowflake schema: it has more normalized. Dimension table has further Dimension attached to it. Problem with snowflakes is we have to join multiple table to get the required data. Star has qualitative schema in the center which is fact and fact has dimension. Snowflake schema is made to narmalize the data.
00:45 Snowflake Schema is a variation of Star Schema.
01:30 Snowflake scheme is used for normalization in a data model.
02:15 Normalization helps to reduce data redundancy and improve data organization.
03:00 Normalization improves data integrity by reducing duplication and ensuring unique values.
03:45 Government mandates city name changes
04:30 Normalizing in data tables reduces redundancy and simplifies updates
05:15 If you want to change the name of Lucknow, then you only need to update it at one place.
05:58 The snowflake schema has advantages in terms of reducing updation and improving query performance by joining multiple tables.
It doesn't improve but downgrade query performance
Sir pleased complete this subject as soon as possible 🥲🥲
Lgta hai sir yogi ji ke fan hai...lucknow ko Lakshmanpur suppose kr rhe hain kr rhe hain😅
He was sarcastic lol 😂
He was taunting 😂
Real name yhi h
Sir, Thanks a lot for This Amazing Lecture 🙂
Lecture - 5 Completed ✅ in Data Warehouse Playlist
Can you please make videos on object oriented software engineering
Presented in a good way easily understandable keep it up and I also do have a question for you " I want to create a snowflake schema of a database which contain different tables. How can I create fact and dimensions tables from them. Is there any rule for creating fact and dimension table or we can create them just by looking at our already created tables in database?"
Any volunteer's answer would be appreciated. Thanks
Good work sir
I am the subscriber from Lucknow.
Very nicely explained. Thank you very much!
Slowflake schema: it has more normalized. Dimension table has further Dimension attached to it. Problem with snowflakes is we have to join multiple table to get the required data.
Star has qualitative schema in the center which is fact and fact has dimension. Snowflake schema is made to narmalize the data.
Wow wonderful video sir ,really thanks for this video, sir pls more videos on types of dim and facts
I will try my best
Thank you so much Sir....
sir try to set captions
There are some non - hindi viewers
sir what about Fact constellation ?
Dashing sir🎉❤
Sir please make a video regarding Data Mining process and Sql
Very nice video 👍👍👍
Very helpful sir ji
thankyou so much sir
sir can u make a video on data mining and data warehousing architecture
Sir Way You Say Lucknow Name Change with " Lakshman" Thise Is dis respect your God Sir 😕
Bro trolled the government for changing the names of the cities and we didn't even realise that🤣
Video useful
Best
yogi ke fan lag rhe hoo😆
sir IBPS SO IT ka notificaqtion aa gya course kabtak aayega
SIR IT OFFICERS KA BATCH LAUNCH KAR DO PLS .
..
Hello sir...... 😊
🎉🎉
i didn't get one thing why we take sales amount as a fact table.
Bcoz every company focusses on sales.