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

    Datamart design review

    Hello,

    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
    Location
    Toronto, Canada
    Posts
    20,002
    this should keep you busy for a while...

    data mart design guidelines

    rudy.ca | @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
  •