HomeЛюди и блогиRelated VideosMore From: Technologies is the most challenges

Explain Star Schema & Snow Flake Design

620 ratings | 80535 views
Html code for embedding videos on your blog
Text Comments (26)
Gerry Abbott (23 days ago)
Great vid. thanks. In the STAR design, would the vendor table be linked directly to the fact table with the ProducId separately from the products.? That would not be normalised. As you have it, the STAR design looks perfectly normalised.
Lily Lincoln (3 months ago)
Thank you
Brian Megilligan (4 months ago)
Can you explain what you mean by “normalized” vs “denormalized?”
Patrick B. (2 months ago)
I know this may be late and you perhaps don't need it anymore but when he says denormalized, he means that the dimension tables are more grouped together. For example, you can group 3 tables like Client, city, and province into 1 client dimension table for simplicity when using OLAP but, you can also normalize tables which is the opposite and u split tables into several, this reduces redundancy sometimes. Hope this helps
nullternative (6 months ago)
Great! Thanks for the video.
Prachi Saxena (7 months ago)
Fantastic explanation.Thank you for taking out time to explain this and benefiting thousands of us.
Ashish Mohan (7 months ago)
Short and crisp. Great explanation. Thank you.
New Age (10 months ago)
Didnt understand anything because I don't know what "Normalized Dimension" means it was repeated a million times in this video.
Makiko Kotobuki (8 months ago)
HYD TECHIE TALKS (9 months ago)
A table Normalized means donot repeat dependent data - so create a foreign key table; Normalized dimension - a dimension table which has some child tables (to be normalized== to avoid repetition of data)
Harshit (1 year ago)
If anyone is planning for certifications like Cognos, Informatica, Tableau, MSBI, Teradata, Oracle, SQL Server, Servicenow or any other we can help you directly to clear exams on your behalf. We also provide proxy interview and job support help. Interested can contact "solankijainsj" at gmail dot com, +91 8019329362
Meghjeet Vartak (1 year ago)
short and great ......useful
Harshal Saindane (1 year ago)
U Know...U Know...U Know...U Know...U Know...U Know... IF I know then why I came here to see ur video now U Know...
Brendan Nadolny (1 year ago)
cause now you know
Data Architect (1 year ago)
nice course on data modeling: https://www.udemy.com/datamodeling/?couponCode=PROMO17
Gaurav Dubey (1 year ago)
Nice explanation thanks alot
Vivek Teega (1 year ago)
nice video, it was helpful
Great explanation sir. Good
Madhulatha Madduri (1 year ago)
hello sir could u plz elaborate the usage guidelines at 4:18 timing...
saksham rewari (1 year ago)
The difference table is good but maybe you shouldn't say exactly what is written, I can read it. Some facts or information related to it would be more helpful. Keep up the good work
Saswato bhattacharyya (1 year ago)
what are facts?
John Zhang, CFA (1 year ago)
Saswato bhattacharyya facts are summaries of dimensions
Ashish U.S (1 year ago)
excellent tutorial
Adarsh Kumar (1 year ago)
great explanation sir. really helpful.
Tehmina Kakar (1 year ago)
Thank you so much
Aishwarya Meow (2 years ago)
Great video helped a lot 👍

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.