Article

Tip #1: Diagram for object inheritance in data modeling

William McKnight

See last week's tip for context.

All the dimensions and attributes are reduced and simplified for representation. This type of Business Object Inheritance

    Requires Free Membership to View

approach will potentially do the followings:

  1. Reduce unwanted overhead of SK and grandfather key.
  2. Help to build categorized OLAP cube
  3. Supply modular information by steps.
  4. Make an organized approach to business objects that, in turn, will give better understanding of business and grouped ETL.
  5. Access for facts can be customized.

For more information, check out SearchCRM's Best Web Links on Data Warehousing.


Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.