Data Modelling - Star Schema, Snowflake Schema

[@ravijeganathan329]

Thank you once again! Crystal clear presentation !

[@Ssinger123]

I m seeing all the video very useful, tq, u ll live long.

[@aashishkshah]

Thanks Kamala for this amazing tutorial.

[@jaswanthbabu4464]

Thanks, Kamala for understanding it better

[@anjaneyulumundru4439]

Thanks sir. ALL my doubts in DWH are cleared..

[@Ravikumar-ub4qq]

thanks kamala for sharing your valuable subject..

[@payalgoel4831]

Nice..👍

[@raviy10]

Thanks a lot !! Very detilaed and useful !!

[@Vanaja.Arigala]

Thank you sir realy very good class. All my doubts is clear. 🙏🙏🙏

[@user-te4yf6mq9h]

Thank you, sir. very good explanation

[@vinodlondhe-cm8lz]

Please add more videos related to data warehouse

[@antoine1407]

What's the difference in primary key and foreign key? thanks

[@anjaneyulumundru4439]

Hi Sir, you are teaching AZURE DATA FACTORY....also

[@vaibhav357]

Sir, I have one doubt in Start Schema as you have said that under this all dimension tables are de-normalized as they will have duplicate values but why these table will have duplicate values these should be unique and the duplicasy should be fact table as only this table will contains the transactional records. pls clarify.

[@TonnyPodiyan]

Assume there is an employee table with emp Id,employee name, Emp Pin code, Emp City. In star schema Here the emp city would be repeated because there could be multiple employees from the same city. In snowflake schema we would have a second table with pincode and city