Using Star Schema | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Using Star Schema

Hi,<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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>