SQL Server Performance Forum – Threads Archive
Using Star SchemaHi,<br /><br />I have tried the following out and would appreciate feedback from experienced users regarding if the following is a good/bad approach:<br /><br />After bring all the data in my Data Mart, I have created a view which has all the data in a big flat table (totally unnormalized). Then based on this BIG FLAT UNNORMALIZED VIEW <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /> I have created my various dimensions using the 1st option i.e. Star Schema.<br /><br />Based on the little testing that I have done, I seem to be getting the correct results across various dimensions… However, can someone kindly comment on this approach and the pros/cons. <br /><br />Thanks
May refer to this BLoghttp://blogs.msdn.com/bi_systems/articles/164502.aspx for the relevant information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.