Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    6

    Why data in a data warehouse is kept in de-normalized form?

    It has been said that when producing a data model for a Data Warehouse, it is not so useful to go through the process of normalisation and that in many cases achieving only First Normal Form is appropriate.
    Can anybody explain me the above mentioned scenario?.

    Thank you !!!!!!

  2. #2
    Join Date
    Mar 2013
    Posts
    6
    any help please

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    No, that sounds like poppycock to me. Maybe if there was some context to the statement it might make sense, but by itself there is a fundamental flaw in the logic that I can't get past.

    The problem boils down to "Please decide in advance if you want a fast answer or a correct answer" and I find that choice unacceptable. There might be mitigating circumstances that you haven't posted that could cast your question in a different light.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Non-normalized datasets may be fine for data "marts" (small, targeted subsets of a true data warehouse), but a data warehouse should begin with normalized data and add aggregations from there.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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