Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Datamart design review


    We have a datamart that receives approx. 6 million records a day into two main fact tables and is a complete beast to report off of. I am fairly certain that the design can be improved but am not sure where to start. Does anyone have any pointers or suggests what to read or what to look at?

    Any information is greatly appreciated and thanks in advance to those who do respond.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    this should keep you busy for a while...

    data mart design guidelines | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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