Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006

    Limitation of Data warehouses, normalisation and data cubes?

    Hi there, can someone tell me please what kinds of things I should look out for when dsigning my data warehouse, building OLAP Cubes and normalisation? What issues and limitations surround them?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    First and foremost, talk with your users. They'll often have a lot of vague ideas, many of which are focused on a specific "pain point" for them, that when analyzed will show you a "big picture" problem that is both easier to solve from an OLAP persepctive, and will serve more people in the long run. In other words, you need to talk with your users, but talk lots with all of them, then think through those discussions. The results will often surprise you!

    The limitations of each product are specific to that product. I don't know of any generic "OLAP Limitations" that apply to every product that is available.


  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    THere's also a couple of database installments in these tutorials that may help as well.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

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