Skip to Content
author's profile photo
Former Member

data normalization

hi,

What is meant by data normalization exactly

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Posted on Aug 24, 2007 at 05:47 AM

    Hi,

    in MDM terms it's one of <b>Master-Data Consolidation</b> scenario parts

    and it includes categorization and taxonomy management

    Regards,

    michal

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 24, 2007 at 06:03 AM

    hi michal,

    thanks for ur reply.I read it in an article that data normalization functionality includes conversion of lower case letters into uppercase letters.How does it come under data consolidation scenario

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 06:52 AM

    Hi - I see some good examples and definitions from the folks. Here's my 2 cents in addition to that, the definition in general in the BI/DW world is:

    - Normalization is the process of organizing your data and breaking it into smaller tables that are easier to manage. The primary reason we normalize a database is to prevent redundant data.

    For further info check out these url's:

    http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88

    http://support.microsoft.com/kb/283878

    Add comment
    10|10000 characters needed characters exceeded