SQL Server Performance

Using Star Schema

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Dec 26, 2004.

  1. Joozh New Member

    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
  2. satya Moderator

Share This Page