Results 1 to 5 of 5

Thread: Using Star Schema

Threaded View

  1. 12-27-2004, 01:58 AM #1
    joozh
    joozh is offline Registered User
    Join Date
    Dec 2003
    Posts
    140

    Using Star Schema

    Hi,

    I have tried the following out and would appreciate feedback from experienced users regarding if the following is a good/bad approach:

    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 I have created my various dimensions using the 1st option i.e. Star Schema.

    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.

    Thanks
    Last edited by joozh; 12-27-2004 at 02:03 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules