Data Modelling - Star Schema, Snowflake Schema

[@Ssinger123]

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

[@ravijeganathan329]

Thank you once again! Crystal clear presentation !

[@aashishkshah]

Thanks Kamala for this amazing tutorial.

[@jaswanthbabu4464]

Thanks, Kamala for understanding it better

[@raviy10]

Thanks a lot !! Very detilaed and useful !!

[@anjaneyulumundru4439]

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

[@vinodlondhe-cm8lz]

Please add more videos related to data warehouse

[@Ravikumar-ub4qq]

thanks kamala for sharing your valuable subject..

[@Vanaja.Arigala]

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

[@antoine1407]

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

[@saisriram-y2w]

Thank you, sir. very good explanation

[@payalgoel4831]

Nice..👍

[@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