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=’![Smile :) :)](styles/default/xenforo/smilies/smile.png)
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.
]]>