Results 1 to 2 of 2

Thread: Normalized vs Denromalized DW

  1. #1
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514

    Normalized vs Denromalized DW

    What are the advantages of having a normalized DW compared to dimensional DW? What are the advantages of dimensional DW compared to normalized DW?

  2. #2
    Senior Member
    Join Date
    Aug 2012
    Posts
    40,312
    The advantages of dimensional DW are:

    • flexibility: we can accommodate changes in the requirements with minimal changes on the data model,
    • Complex queries: you can query it faster than normalized model as there is need to join only few tables
    • itís quicker and simpler to develop than normalized DW and easier to maintain.

Similar Threads

  1. Replies: 1
    Last Post: 07-26-2012, 10:16 AM

Bookmarks

Posting Permissions

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