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.
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.
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
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
Such a wonderful explanation.. thank u so much for all your efforts.
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
It was sarcasm actually…
Can you please make videos on object oriented software engineering
Sir, Thanks a lot for This Amazing Lecture 🙂
Lecture - 5 Completed ✅ in Data Warehouse Playlist
Wow wonderful video sir ,really thanks for this video, sir pls more videos on types of dim and facts
I will try my best
Very nicely explained. Thank you very much!
I am the subscriber from Lucknow.
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.
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
Sir please make a video regarding Data Mining process and Sql
sir try to set captions
There are some non - hindi viewers
sir can u make a video on data mining and data warehousing architecture
Thank you so much Sir....
Sir Way You Say Lucknow Name Change with " Lakshman" Thise Is dis respect your God Sir 😕
Very helpful sir ji
Very nice video 👍👍👍
sir what about Fact constellation ?
Dashing sir🎉❤
Video useful
Sir lagta hai yogiji se bhi jaldi hai Lucknow ka name change karne ki
Bro trolled the government for changing the names of the cities and we didn't even realise that🤣
thankyou so much sir
sir IBPS SO IT ka notificaqtion aa gya course kabtak aayega
SIR IT OFFICERS KA BATCH LAUNCH KAR DO PLS .
..
yogi ke fan lag rhe hoo😆
i didn't get one thing why we take sales amount as a fact table.
Bcoz every company focusses on sales.
Best
Hello sir...... 😊
🎉🎉